Cessna A150L
FAA incident reports · 106
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 ('2071828')
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 ('2071828')
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 19731025034389ACessna 150L · CAAccident 19730923034469ACessna A150K · Holly, MILost ctl drg low alt roll near relatives house.Accident 19730810033159ACessna A150K · CAAccident 19730810026759ACessna A150L · Mayville, NDAcft struck parked truck. Lndd in a stubble fldAccident 19730610025579ACessna A150L · San Jose, CAStruck light standard and fence.Accident 19730607013949ACessna A150K · Playa D.Rey, CAFlew into fog on 3rd solo flt. Ip clrd plt to fly in pattern with fog bank nearby. Acft sank.
Back to Cessna A150L