NTSB investigations: Lycoming 0-320 series, FL
6 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Aerodynamic stall/spin. 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
| 2008 | 1 |
|---|---|
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 1 |
Where
Latest 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\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241'))
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" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '241'))
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 ERA26LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Pensacola, FLThe pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.NTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.NTSB ERA23FA323Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Pembroke Pines, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent rapid descent into terrain.NTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.NTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.NTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.