Fatal NTSB investigations: Lycoming IO-720 series
5 cases on aircraft whose registry engine model is Lycoming IO-720 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
| 1982 | 2 |
|---|---|
| 1991 | 1 |
| 2009 | 1 |
| 2010 | 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.\"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 ('41546'))
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."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 ('41546'))
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 ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB ERA09FA303Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Daytona Beach, FLA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight inspection.NTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.NTSB FTW82FRJ12Accident · 1 fatalFinal reportPiper PA-36-375 · Wildsville, LAThe pilot took off on a local flight to spray a bean field. About 1000 ft from the end of the field was a 300 ft radio tower. The aircraft was observed to circle the bean field and circle the radio tower twice. During a procedure turn, the aircraft struck the…NTSB FTW82FQG15Accident · 1 fatalFinal reportPiper PA-36 · Floydada, TXThe aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No…