NTSB investigations: Cessna 150M, IL
71 cases on aircraft the registry lists as Cessna 150M. 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, newest first
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\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
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" = 'IL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
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 CHI77FEE25Accident · No injuriesClosedCessna 150 · West Chicago, ILNTSB CHI77DEE22Accident · No injuriesClosedCessna 150 · Lansing, ILNTSB CHI77FEE19Accident · Minor injuriesClosedCessna 150M · Kankakee, ILNTSB CHI77DCA03Accident · Minor injuriesClosedCessna 150M · Alton, ILNTSB CHI77DEV12Accident · No injuriesClosedCessna 150M · Lawrenceville, ILNTSB CHI77FEV09Accident · No injuriesClosedCessna 150 · Peoria, ILNTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILNTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILNTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNTSB CHI76AC090Accident · 2 fatalClosedCessna 150M · Salem, ILNTSB CHI76FEE74Accident · 1 fatalClosedCessna 150M · Lockport, ILNTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILNTSB CHI76AC067Accident · 1 fatalClosedCessna 150M · Peoria, ILNTSB CHI76FEV42Accident · No injuriesClosedCessna 150M · Springfield, ILNTSB CHI76FEV39Accident · No injuriesClosedCessna 150M · Springfield, ILNTSB CHI76FEE50Accident · No injuriesClosedCessna 150M · Justice, ILNTSB CHI76DEE41Accident · No injuriesClosedCessna 150 · Lockport, ILNTSB CHI76FCA04Accident · No injuriesClosedCessna 150M · Alton, ILNTSB CHI76FEE29Accident · No injuriesClosedCessna 150M · Wilmington, ILNTSB CHI76AC010Accident · 1 fatalClosedCessna 150M · Harvard, ILNTSB CHI75DEV13Accident · No injuriesClosedCessna 150M · Mattoon, IL