Fatal NTSB investigations: Lycoming O&VO-360 series, IN
9 cases on aircraft whose registry engine model is Lycoming O&VO-360 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1969 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 2001 | 1 |
| 2012 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.NTSB CHI01FA204Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Lafayette, INThe fuel exhaustion due to the pilot's alcohol impaired decision making. Additional factors were the trees and night.NTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.NTSB CHI86FA077Accident · 2 fatalField investigationFinal reportMooney M20C · Loogootee, INPlt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine…NTSB CHI83FA042Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Mccutchanville, INAt about 0401 EST, the pilot took off on an IFR flight and was cleared to climb and maintain 6000 ft MSL. Radar contact was established at about 0402. After about another 30 seconds, radar contact was lost. The aircraft impacted about 3 to 4 mi from the…NTSB CHI81FA064Accident · 2 fatalClosedBrantley B2B · Chesterton, INNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INNTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, INNTSB CHI70A0041Accident · 2 fatalClosedPiper PA-28 · Franklin, IN