Fatal NTSB investigations: Lycoming AEIO-320 series
4 cases on aircraft whose registry engine model is Lycoming AEIO-320 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
| 1980 | 1 |
|---|---|
| 1982 | 2 |
| 1985 | 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 ('41500', '41567'))
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 ('41500', '41567'))
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 NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…NTSB LAX82FA225Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Westley, CAThe plt made a low pass over a ranch house traveling from nw to se. He then made a second low pass over the swimming pool area traveling in a NE direction, & waved to those standing by the pool. The acft began a 180 reversal turn, entered a steep nose down…NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…NTSB LAX81FUJ11Accident · 1 fatalClosedBellanca 8KCAB · Bouse, AZ