NTSB investigations: Cessna A188B, 1981

66 cases on aircraft the registry lists as Cessna A188B. 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 year(c.\"eventDate\") = 1981
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005'))
  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 CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNMay 7, 1981 · N9207R · Substantial damageNTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 5, 1981 · N4729Q · Substantial damageNTSB FTW81DPA10Accident · No injuriesClosedCessna A188B · Gunter, TXMay 1, 1981 · N4707Q · Substantial damageNTSB FTW81DRA23Accident · No injuriesClosedCessna 188 · Francitas, TXApr 20, 1981 · N731RP · Substantial damageNTSB MKC81FCQ30Accident · No injuriesClosedCessna 188 · Selden, KSApr 18, 1981 · N8107G · Substantial damageNTSB MKC81FCQ27Accident · Serious injuriesClosedCessna 188B · Roxbury, KSApr 15, 1981 · N86236 · DestroyedNTSB MKC81FCQ25Accident · Minor injuriesClosedCessna A188B · Mcpherson, KSApr 12, 1981 · N21738 · Substantial damageNTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNApr 10, 1981 · N6315G · DestroyedNTSB ATL81FA061Accident · 1 fatalClosedCessna 188B · Hernando, MSApr 10, 1981 · N21862 · Substantial damageNTSB MKC81FCQ24Accident · No injuriesClosedCessna 188B · Mcpherson, KSApr 9, 1981 · N70058 · Substantial damageNTSB FTW81DPJ15Accident · No injuriesClosedCessna 188 · Seiling, OKApr 9, 1981 · N4830R · Substantial damageNTSB ATL81FLT05Accident · No injuriesClosedCessna 188 · Byhalia, MSApr 2, 1981 · N21818 · DestroyedNTSB FTW81DPJ13Accident · No injuriesClosedCessna A188B · Cherokee, OKApr 1, 1981 · N731AM · Substantial damageNTSB FTW81DPD15Accident · No injuriesClosedCessna 188 · Throckmorton, TXMar 13, 1981 · N4818R · Substantial damageNTSB FTW81DPJ11Accident · Serious injuriesClosedCessna A188B · Duncan, OKMar 11, 1981 · N86547 · DestroyedNTSB MKC81DCQ11Accident · No injuriesClosedCessna 188 · Plains, KSJan 28, 1981 · N731SM · Substantial damage