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.

NTSB CHI77FEE25Accident · No injuriesClosedCessna 150 · West Chicago, ILJun 16, 1977 · N704XZ · Substantial damageNTSB CHI77DEE22Accident · No injuriesClosedCessna 150 · Lansing, ILApr 30, 1977 · N9235U · Substantial damageNTSB CHI77FEE19Accident · Minor injuriesClosedCessna 150M · Kankakee, ILApr 16, 1977 · N45127 · Substantial damageNTSB CHI77DCA03Accident · Minor injuriesClosedCessna 150M · Alton, ILApr 14, 1977 · N704KK · Substantial damageNTSB CHI77DEV12Accident · No injuriesClosedCessna 150M · Lawrenceville, ILFeb 15, 1977 · N66378 · Substantial damageNTSB CHI77FEV09Accident · No injuriesClosedCessna 150 · Peoria, ILJan 29, 1977 · N9336U · Substantial damageNTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILDec 18, 1976 · N63406 · Substantial damageNTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILDec 4, 1976 · N9172U · Substantial damageNTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNov 24, 1976 · N8778U · Substantial damageNTSB CHI76AC090Accident · 2 fatalClosedCessna 150M · Salem, ILSep 7, 1976 · N6244K · DestroyedNTSB CHI76FEE74Accident · 1 fatalClosedCessna 150M · Lockport, ILAug 24, 1976 · N7TZ · Substantial damageNTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · DestroyedNTSB CHI76AC067Accident · 1 fatalClosedCessna 150M · Peoria, ILJun 9, 1976 · N66101 · DestroyedNTSB CHI76FEV42Accident · No injuriesClosedCessna 150M · Springfield, ILJun 5, 1976 · N8993U · Substantial damageNTSB CHI76FEV39Accident · No injuriesClosedCessna 150M · Springfield, ILMay 19, 1976 · N66380 · Substantial damageNTSB CHI76FEE50Accident · No injuriesClosedCessna 150M · Justice, ILApr 9, 1976 · N3335V · Substantial damageNTSB CHI76DEE41Accident · No injuriesClosedCessna 150 · Lockport, ILJan 30, 1976 · N8AZ · Substantial damageNTSB CHI76FCA04Accident · No injuriesClosedCessna 150M · Alton, ILNov 16, 1975 · N63556 · Substantial damageNTSB CHI76FEE29Accident · No injuriesClosedCessna 150M · Wilmington, ILOct 29, 1975 · N66208 · Substantial damageNTSB CHI76AC010Accident · 1 fatalClosedCessna 150M · Harvard, ILAug 4, 1975 · N45413 · DestroyedNTSB CHI75DEV13Accident · No injuriesClosedCessna 150M · Mattoon, ILNov 20, 1974 · N66072 · Substantial damage