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.
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" 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 CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNNTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDNTSB FTW81DPA10Accident · No injuriesClosedCessna A188B · Gunter, TXNTSB FTW81DRA23Accident · No injuriesClosedCessna 188 · Francitas, TXNTSB MKC81FCQ30Accident · No injuriesClosedCessna 188 · Selden, KSNTSB MKC81FCQ27Accident · Serious injuriesClosedCessna 188B · Roxbury, KSNTSB MKC81FCQ25Accident · Minor injuriesClosedCessna A188B · Mcpherson, KSNTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNNTSB ATL81FA061Accident · 1 fatalClosedCessna 188B · Hernando, MSNTSB MKC81FCQ24Accident · No injuriesClosedCessna 188B · Mcpherson, KSNTSB FTW81DPJ15Accident · No injuriesClosedCessna 188 · Seiling, OKNTSB ATL81FLT05Accident · No injuriesClosedCessna 188 · Byhalia, MSNTSB FTW81DPJ13Accident · No injuriesClosedCessna A188B · Cherokee, OKNTSB FTW81DPD15Accident · No injuriesClosedCessna 188 · Throckmorton, TXNTSB FTW81DPJ11Accident · Serious injuriesClosedCessna A188B · Duncan, OKNTSB MKC81DCQ11Accident · No injuriesClosedCessna 188 · Plains, KS