NTSB investigations: Lycoming 0-320 series, MN
5 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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 | 1 |
|---|---|
| 1984 | 1 |
| 1991 | 2 |
| 1998 | 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\" = 'MN' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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" = 'MN' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI92LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maple Lake, MNThe loss of engine power for an undetermined reason.NTSB CHI91LA170Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Albany, MNThe cfi's failure to take timely and proper remedial action when the student pilot lost directional control during the takeoff roll. Factors in the accident are the tall grass edging the runway, and the student pilot's lack of total experience.NTSB CHI84LA199Accident · Serious injuriesLimited investigationFinal reportMeyers LIL Toot · White Bear Lake, MNPlt reported power loss while on initial climb. The left wing contacted the ground and the acft cartwheeled. Examinationof aircraft by FAA disclosed no malfunction of aircraft or of powerplant.NTSB CHI82DA300Accident · No injuriesFinal reportPiper PA-28-161 · Brainerd, MNWhile on the landing roll, the engine quit operating and the pilot turned off onto a taxiway. He then attempted to restart the hot engine. During this time, smoke began coming from under the engine cowling. The pilot exited from the aircraft and noted a small…