Final NTSB investigations: Lycoming 0-350 series
9 cases on aircraft whose registry engine model is Lycoming 0-350 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
| 1965 | 1 |
|---|---|
| 1971 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2001 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41512'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41512'))
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 IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB MIA89IA156Incident · No injuriesIncident investigationFinal reportTemco GC-1B · Crestview, FLFailure of the pilots to maintain directional control of the aircraft. Contributing to the incident was the crosswind and lack of brakes avialable to the pilot-in-command (PIC).NTSB LAX87FA196Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Newhall, CAAt about 1440 PDT, the non-instrument rated plt depd antioch CA, on a flt to burbank, CA. No known in-flt communicationswere made until the plt contacted TRACON at 1725 PDT. At that time, he rprtd inbound at 7500' & requested a special VFR clnc to the arpt.…NTSB CHI83LA055Accident · No injuriesLimited investigationFinal reportCessna 175 · Neenah, WIPilot took off in short ground run. Crosswind blew aircraft to east side of runway. No climb established. Aircraft flew into trees alongside runway. Alignment with runway not maintained.NTSB MKC78FCG37Accident · No injuriesClosedPiper PA-28R · Springfield, MONTSB ANC77DAA46Accident · Minor injuriesClosedPiper PA-18 · Fairbanks, AKNTSB MKC72DCD06Accident · Minor injuriesClosedPiper PA-18 · Thayer, IANTSB ANC71DAG66Accident · No injuriesClosedPiper PA-18 · Gakona, AKNTSB CHI66F0018Accident · Minor injuriesClosedSwift GC1B · Versailles, OH