Skip to content

NTSB investigations · 1,320

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 ('2071602', '2071603') 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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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 CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYAug 28, 1966 · N4022N · Substantial damage NTSB CHI67D0589Accident · No injuriesClosedCessna 140 · Spring Bay, ILAug 24, 1966 · N1965N · Substantial damage NTSB FTW67F0388Accident · No injuriesClosedCessna 140 · Lipan, TXAug 18, 1966 · N1722V · Substantial damage NTSB NYC67F0188Accident · Minor injuriesClosedCessna 140 · Princess Anne, MDAug 15, 1966 · N76942 · Substantial damage NTSB LAX67D0076Accident · No injuriesClosedCessna 140A · Daggett, CAAug 13, 1966 · N2497V · Substantial damage NTSB MKC67D0155Accident · No injuriesClosedCessna 140 · La Porte Cty, IAAug 10, 1966 · N1999N · Substantial damage NTSB FTW67F0145Accident · Minor injuriesClosedCessna 140 · Canton, TXAug 9, 1966 · N2193V · Substantial damage NTSB MKC67D0098Accident · No injuriesClosedCessna 140 · Wells, MNAug 7, 1966 · N76346 · Substantial damage NTSB ANC67D0037Accident · No injuriesClosedCessna 140 · Elmendorf Ab, AKJul 29, 1966 · N76619 · Substantial damage NTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARJul 24, 1966 · N3192N · Destroyed NTSB CHI67F0093Accident · 1 fatalClosedCessna 140 · Freaser, MIJul 22, 1966 · N2378N · Destroyed NTSB NYC67F0113Accident · No injuriesClosedCessna 140 · Ilion, NYJul 15, 1966 · N1931N · Substantial damage NTSB LAX67D0051Accident · No injuriesClosedCessna 140 · Roll, AZJul 6, 1966 · N89408 · Substantial damage NTSB NYC67F0017Accident · No injuriesClosedCessna 140 · Fitchburg, MAJun 30, 1966 · N4194N · Substantial damage NTSB DEN67F0176Accident · 1 fatalClosedCessna 140 · Broomfield, COJun 30, 1966 · N72276 · Destroyed NTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damage NTSB MKC67D0092Accident · No injuriesClosedCessna 140 · Kirkville, MOJun 26, 1966 · N76387 · Substantial damage NTSB MKC67F0015Accident · No injuriesClosedCessna 140 · Des Moines, IAJun 21, 1966 · N3621V · Substantial damage NTSB MKC67D0014Accident · No injuriesClosedCessna 140 · Corning, IAJun 11, 1966 · N76644 · Substantial damage NTSB CHI67D0029Accident · No injuriesClosedCessna 140 · Madison, WIJun 10, 1966 · N72919 · Substantial damage NTSB OAK67D0089Accident · No injuriesClosedCessna 140 · Las Vegas, NVJun 4, 1966 · N3588V · Substantial damage NTSB MIA67D0047Accident · No injuriesClosedCessna 140 · Blairsville, GAJun 3, 1966 · N2511N · Substantial damage NTSB FTW66A0111Accident · 2 fatalClosedCessna 140 · Gordonville, TXJun 1, 1966 · N72385 · Destroyed NTSB LAX66F0375Accident · Minor injuriesClosedCessna 140 · San Diego, CAMay 31, 1966 · N3135N · Substantial damage NTSB OAK66F0286Accident · No injuriesClosedCessna 140 · Truckee, CAMay 21, 1966 · N76395 · Substantial damage NTSB NYC66D0699Accident · No injuriesClosedCessna 140 · Inlet, NYMay 20, 1966 · N72954 · Substantial damage NTSB OAK67D0023Accident · No injuriesClosedCessna 140 · Angels Camp, CAMay 19, 1966 · N2370V · Substantial damage NTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCMay 18, 1966 · N73023 · Substantial damage NTSB MIA67D0051Accident · No injuriesClosedCessna 140 · Statesville, NCMay 14, 1966 · N3156N · Substantial damage NTSB DEN66D0311Accident · No injuriesClosedCessna 140 · Watkins, COMay 13, 1966 · N1667V · Substantial damage NTSB MIA66F0560Accident · No injuriesClosedCessna 140 · Auburndale, FLMay 12, 1966 · N76430 · Substantial damage NTSB DEN66D0334Accident · No injuriesClosedCessna 140 · Las Cruces, NMMay 10, 1966 · N1930N · Destroyed NTSB NYC66D0666Accident · No injuriesClosedCessna 140 · Montgomery, NYMay 4, 1966 · N1866V · Substantial damage NTSB OAK66D0280Accident · No injuriesClosedCessna 140 · Franklin, CAMay 2, 1966 · N74U · Substantial damage NTSB MIA66D0530Accident · Minor injuriesClosedCessna 140 · Eupora, MSMay 1, 1966 · N76653 · Substantial damage NTSB SEA67F0007Accident · No injuriesClosedCessna 140 · Medford, ORApr 27, 1966 · N2172V · Substantial damage NTSB SEA67D0002Accident · No injuriesClosedCessna 140 · Crane Island, WAApr 24, 1966 · N77086 · Substantial damage NTSB MKC66A0053Accident · 1 fatalClosedCessna 140 · Savannah, MOApr 24, 1966 · N3576V · Destroyed NTSB CHI66F0666Accident · No injuriesClosedCessna 140 · Milwaukee, WIApr 16, 1966 · N89523 · Substantial damage NTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORApr 15, 1966 · N3713V · Substantial damage NTSB CHI66F0730Accident · No injuriesClosedCessna 140 · Springfield, ILApr 3, 1966 · N77365 · Substantial damage NTSB CHI66D0663Accident · No injuriesClosedCessna 140 · Ann Arbor, MIMar 27, 1966 · N4147N · Substantial damage NTSB NYC66D0568Accident · No injuriesClosedCessna 140 · Corry, PAMar 21, 1966 · N89404 · Substantial damage NTSB MKC66F0480Accident · Minor injuriesClosedCessna 140 · St Joseph, MOMar 18, 1966 · N89555 · Substantial damage NTSB FTW66F0538Accident · No injuriesClosedCessna 140 · Sulphur Sps, TXMar 15, 1966 · N3180N · Substantial damage NTSB MKC66F0473Accident · Minor injuriesClosedCessna 140 · Miltonvale, KSMar 11, 1966 · N4125N · Substantial damage NTSB FTW66F0574Accident · Minor injuriesClosedCessna 140 · Houston, TXMar 5, 1966 · N76962 · Substantial damage NTSB MKC66D0491Accident · Minor injuriesClosedCessna 140 · Coffeyvill, KSFeb 28, 1966 · N76152 · Destroyed NTSB MIA66D0477Accident · No injuriesClosedCessna 140 · Merritt Is, FLFeb 19, 1966 · N2458N · Substantial damage

Back to Cessna 140