Cessna 140
FAA incident reports · 861
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2071602', '2071603')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2071602', '2071603')
ORDER BY event_date DESC, report_number 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.
Accident 19730524013679ACessna 14* · Valley Park, MOEng missed,backfired,lost pwr.Accident 19730523013159ACessna 140 · Marietta, GAGrass on strip abt 4-15IN long,acft became airborne with insufficient speed t/d on rwy,t/o abortedAccident 19730514018299ACessna 140 · Grand Rapids, MNR fuel tank empty,l 1/4 full selector in off psn.Accident 19730509027329ACessna 140 · Anoka, MNCrashed into swamp. Carb float level set too lowAccident 19730422011599ACessna 14* · Hillsboro, NDLeft side engine cowl hinge opened aftr tkof. Atmtd turn back to arpt. Aprx 180DEG turn,nose droppedAccident 19730328007929ACessna 140 · Goldsby, OKTouch and go ldg rwy 35.Accident 19730318004319ACessna 140 · Rampart, AKPlt landed rwy 11.wind gustyAccident 19730304003819ACessna 14* · Van Nuys, CAInsufficient fuel for flt.Accident 19730124000919ACessna 14* · Manchester, NHDuring taxi PIC failed to maintain directional control due to sudden wind gust l brake failed.Accident 19730120002729ACessna 140 · Levering, MISnow cvrd plowed fld. Plt though snow deeper than it actually was.Accident 19730107000499ACessna 140 · Plymouth, MIIce found in line to fuel bowl.
Back to Cessna 140