Skip to content

NTSB investigations · 325

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2072722') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2072722')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072722')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 OAK67D0241Accident · No injuriesClosedCessna 182J · Lone Pine, CAJan 17, 1967 · N3105F · Substantial damage NTSB OAK67D0208Accident · Minor injuriesClosedCessna 182 · Haleo Lono, HIJan 17, 1967 · N2698F · Destroyed NTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VADec 2, 1966 · N3360F · Destroyed NTSB DEN37D0151Accident · No injuriesClosedCessna 182 · Farmington, NMNov 17, 1966 · N3140F · Substantial damage NTSB MKC67F0282Accident · Serious injuriesClosedCessna 182J · Waterloo, IANov 2, 1966 · N2905F · No damage NTSB DEN67D0154Accident · No injuriesClosedCessna 182 · Rock River, WYOct 11, 1966 · N3579F · Substantial damage NTSB MIA67D0238Accident · No injuriesClosedCessna 182J · Wallace, NCSep 30, 1966 · N2916F · Substantial damage NTSB CHI67D0371Accident · No injuriesClosedCessna 182 · Macomb, ILSep 22, 1966 · N2412Q · Substantial damage NTSB SEA67D0140Accident · No injuriesClosedCessna 182 · Moses Lake, WASep 20, 1966 · N2934F · Substantial damage NTSB NYC67F0197Accident · No injuriesClosedCessna 182J · Coxsackie, NYAug 28, 1966 · N3471F · Destroyed NTSB MKC67D0177Accident · No injuriesClosedCessna 182J · Minden, NEAug 15, 1966 · N2852F · Substantial damage NTSB NYC67F0155Accident · No injuriesClosedCessna 182 · Red Hook, NYJul 31, 1966 · N2680F · Substantial damage NTSB MIA67F0071Accident · No injuriesClosedCessna 182 · Charlotte, NCJul 29, 1966 · N2938F · Substantial damage NTSB NYC67D0101Accident · No injuriesClosedCessna 182J · Rock Hall, MDJul 22, 1966 · N2899F · Substantial damage NTSB NYC67F0078Accident · Minor injuriesClosedCessna 182J · Roanoke, VAJul 8, 1966 · N2826F · Substantial damage NTSB CHI67F0040Accident · No injuriesClosedCessna 182 · West Chicago, ILJun 23, 1966 · N2869F · Substantial damage NTSB SEA67F0071Accident · No injuriesClosedCessna 182 · Lester, WAJun 19, 1966 · N3040F · Substantial damage NTSB LAX67F0015Accident · Serious injuriesClosedCessna 182J · Navajo, AZJun 11, 1966 · N3307F · Destroyed NTSB CHI67D0324Accident · No injuriesClosedCessna 182 · Chicago, ILJun 2, 1966 · N2860F · Substantial damage NTSB OAK66D0295Accident · No injuriesClosedCessna 182H · Monterey, CAApr 30, 1966 · N2702F · Substantial damage NTSB DEN66F0300Accident · No injuriesClosedCessna 182 · Albuquerque, NMApr 30, 1966 · N2793F · Substantial damage NTSB DEN66D0290Accident · No injuriesClosedCessna 182 · Douglas, AZApr 9, 1966 · N2616F · Substantial damage NTSB CHI66F0652Accident · No injuriesClosedCessna 182 · Cincinnati, OHApr 1, 1966 · N2636F · Substantial damage NTSB FTW66F0559Accident · No injuriesClosedCessna 182 · Dalhart, TXMar 17, 1966 · N2675F · Substantial damage NTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSDec 31, 1965 · N2621F · Substantial damage

Back to Cessna 182J