Skip to content

NTSB investigations · 595

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 ('2072420') 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 ('2072420')
  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 ('2072420')
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 NYC67F0584Accident · Minor injuriesClosedCessna 172 · Harrow, PAApr 6, 1967 · N1196F · Destroyed NTSB NYC67D0581Accident · No injuriesClosedCessna 172G · Flushing, NYApr 4, 1967 · N4168L · Substantial damage NTSB DEN67D0256Accident · No injuriesClosedCessna 172G · Colo.Springs, COApr 4, 1967 · N4338L · Substantial damage NTSB DIA67F0070Accident · Minor injuriesClosedCessna 172 · Richmond, VAApr 2, 1967 · N4348L · Substantial damage NTSB CHI67F0609Accident · No injuriesClosedCessna 172 · Ottawa, ILMar 24, 1967 · N6059R · Substantial damage NTSB OAK67D0290Accident · No injuriesClosedCessna 172 · San Carlos, CAMar 19, 1967 · N3926L · Substantial damage NTSB NYC67D0571Accident · Minor injuriesClosedCessna 172 · Ambler, PAMar 17, 1967 · N3815L · Substantial damage NTSB DEN67D0227Accident · No injuriesClosedCessna 172G · Montrose, CAMar 14, 1967 · N3884L · Substantial damage NTSB MIA67F0438Accident · No injuriesClosedCessna 172 · Opa Locka, FLMar 13, 1967 · N3618L · Substantial damage NTSB MIA67F0422Accident · Minor injuriesClosedCessna 172 · Opa Locka, FLMar 12, 1967 · N3940L · Substantial damage NTSB OAK67D0311Accident · No injuriesClosedCessna 172 · Antioch, CAMar 11, 1967 · N4344L · Substantial damage NTSB CHI67D0584Accident · No injuriesClosedCessna 172G · Cahokia, ILMar 10, 1967 · N4699L · Substantial damage NTSB LAX67F0339Accident · No injuriesClosedCessna 172 · Van Nuys, CAMar 7, 1967 · N6060R · Substantial damage NTSB MKC67D0478Accident · No injuriesClosedCessna 172 · Eldora, IAMar 6, 1967 · N4186L · Substantial damage NTSB MIA67D0427Accident · No injuriesClosedCessna 172 · Nashville, TNMar 4, 1967 · N4159L · Substantial damage NTSB NYC67F0517Accident · Minor injuriesClosedCessna 172G · Montauk, NYFeb 26, 1967 · N1335F · Destroyed NTSB OAK68D0177Accident · No injuriesClosedCessna 172 · Colusa, CAFeb 22, 1967 · N4659L · Substantial damage NTSB DEN67D0222Accident · No injuriesClosedCessna 172 · Denver, COFeb 21, 1967 · N3603L · Substantial damage NTSB CHI67D0501Accident · No injuriesClosedCessna 172 · Oshkosh, WIFeb 21, 1967 · N1370F · Substantial damage NTSB FTW67D0448Accident · Minor injuriesClosedCessna 172 · West Helena, ARFeb 19, 1967 · N3691L · Substantial damage NTSB FTW67F0464Accident · Minor injuriesClosedCessna 172 · Friendswood, TXFeb 15, 1967 · N1379F · Substantial damage NTSB MKC67A0047Accident · 2 fatalClosedCessna 172G · Warrensburg, MOFeb 13, 1967 · N4403L · Destroyed NTSB MIA67D0403Accident · No injuriesClosedCessna 172 · Lafayette, TNFeb 13, 1967 · N3724L · Substantial damage NTSB FTW67D0444Accident · No injuriesClosedCessna 172 · Newkirk, OKFeb 10, 1967 · N3683L · Substantial damage NTSB FTW67D0418Accident · No injuriesClosedCessna 172 · Buras, LAFeb 2, 1967 · N4405L · Substantial damage NTSB NYC67F0426Accident · No injuriesClosedCessna 172 · Readington, NJJan 2, 1967 · N441TS · Substantial damage NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67F0347Accident · Minor injuriesClosedCessna 172G · Pearland, TXDec 19, 1966 · N3728L · Substantial damage NTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · Destroyed NTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILDec 6, 1966 · N6088R · Substantial damage NTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MIDec 2, 1966 · N6041R · Substantial damage NTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNov 25, 1966 · N5791R · Destroyed NTSB OAK67F0192Accident · Minor injuriesClosedCessna 172G · San Jose, CANov 23, 1966 · N4363L · Substantial damage NTSB MKC67A0036Accident · 2 fatalClosedCessna 172G · Elkhorn, IANov 23, 1966 · N4170L · Destroyed NTSB FTW67D0319Accident · No injuriesClosedCessna 172 · Norman, OKNov 20, 1966 · N5950R · Substantial damage NTSB NYC67A0078Accident · 1 fatalClosedCessna 172G · Greenwich, CTNov 10, 1966 · N4194L · Destroyed NTSB MKC67A0033Accident · 1 fatalClosedCessna 172G · Venango, NENov 3, 1966 · N3646L · Destroyed NTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILOct 20, 1966 · N3891L · Substantial damage NTSB ANC67D0069Accident · No injuriesClosedCessna 172G · Kenai, AKOct 20, 1966 · N4372L · Substantial damage NTSB FTW67D0274Accident · No injuriesClosedCessna 172 · Bartlesville, OKOct 14, 1966 · N4206L · Substantial damage NTSB DEN67F0169Accident · No injuriesClosedCessna 172 · Panguitch, UTOct 14, 1966 · N3659L · Substantial damage NTSB LAX67D0168Accident · No injuriesClosedCessna 172G · Winslow, AZOct 13, 1966 · N5917R · Substantial damage NTSB DEN67D0130Accident · No injuriesClosedCessna 172 · Denver, COOct 13, 1966 · N3905L · Substantial damage NTSB CHI67D0286Accident · No injuriesClosedCessna 172 · Waukesha, WIOct 4, 1966 · N3896L · Substantial damage NTSB LAX67D0155Accident · Minor injuriesClosedCessna 172 · Sonoita, AZOct 2, 1966 · N5932R · Destroyed NTSB SEA67D0149Accident · No injuriesClosedCessna 172 · Puyallup, WASep 19, 1966 · N5757R · Substantial damage NTSB OAK67D0169Accident · No injuriesClosedCessna 172 · San Carlos, CASep 16, 1966 · N4305L · Substantial damage NTSB MKC67D0230Accident · Minor injuriesClosedCessna 172 · Caldwell, KSSep 14, 1966 · N4392L · Substantial damage NTSB SEA67D0155Accident · No injuriesClosedCessna 172 · Snohomish, WASep 13, 1966 · N5789R · Substantial damage NTSB CHI67D0186Accident · No injuriesClosedCessna 172 · Greenville, OHSep 11, 1966 · N5935R · Substantial damage

Back to Cessna 172G