Skip to content

NTSB investigations · 330

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 ('2072410') 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 ('2072410')
  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 ('2072410')
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 CHI69F0214Accident · No injuriesClosedCessna 172 · Columbus, OHAug 31, 1968 · N2470U · Substantial damage NTSB SEA69A0017Accident · 2 fatalClosedCessna 172 · Lopez, WAAug 28, 1968 · N2520Y · Destroyed NTSB NYC69D0153Accident · No injuriesClosedCessna 172 · Lincoln, MEAug 25, 1968 · N2633U · Substantial damage NTSB MKC69D0201Accident · No injuriesClosedCessna 172 · Springfield, MOJul 16, 1968 · N2145Y · Substantial damage NTSB NYC69D0042Accident · No injuriesClosedCessna 172 · Edinburg, NYJul 11, 1968 · N2359U · Substantial damage NTSB DEN69F0033Accident · No injuriesClosedCessna 172 · Salt Lake City, UTJul 8, 1968 · N2590Y · Substantial damage NTSB MKC69F0006Accident · Minor injuriesClosedCessna 172 · Memphis, MOApr 18, 1968 · N2961U · Substantial damage NTSB DIA68D0194Accident · Minor injuriesClosedCessna 172D · New Market, VAApr 14, 1968 · N2570Y · Substantial damage NTSB SEA68F0301Accident · No injuriesClosedCessna 172 · Hammond, MTApr 7, 1968 · N2049Y · Substantial damage NTSB ANC68D0106Accident · No injuriesClosedCessna 172 · Wrangell, AKMar 29, 1968 · N2658U · Destroyed NTSB MKC68D0480Accident · Minor injuriesClosedCessna 172D · St Marys, KSMar 5, 1968 · N2467Y · Destroyed NTSB MIA68D0434Accident · Minor injuriesClosedCessna 172 · Isabela, PRFeb 23, 1968 · N2670U · Substantial damage NTSB OAK68D0300Accident · Minor injuriesClosedCessna 172 · Tahoe City, CAFeb 16, 1968 · N2529Y · Destroyed NTSB MKC68D0416Accident · No injuriesClosedCessna 172D · Chadron, NEJan 3, 1968 · N2651U · Substantial damage NTSB NYC68F0339Accident · No injuriesClosedCessna 172 · Gardenville, NYJan 1, 1968 · N2583U · Substantial damage NTSB MIA68D0430Accident · Minor injuriesClosedCessna 172D · Chester, SCDec 7, 1967 · N2839U · Destroyed NTSB FTW68F0237Accident · No injuriesClosedCessna 172 · Houston, TXSep 17, 1967 · N2802U · Destroyed NTSB MIA68F0160Accident · No injuriesClosedCessna 172 · Salinas, PRSep 6, 1967 · N2160Y · Substantial damage NTSB MIA68D0156Accident · No injuriesClosedCessna 172 · Vero Beach, FLAug 21, 1967 · N2494U · Substantial damage NTSB MIA68F0118Accident · No injuriesClosedCessna 172 · Bruce, MSAug 16, 1967 · N2580Y · Substantial damage NTSB NYC68F0023Accident · Minor injuriesClosedCessna 172 · Central City, PAJun 15, 1967 · N2749U · Substantial damage NTSB MKC68D0001Accident · No injuriesClosedCessna 172 · Marion, IAMay 24, 1967 · N2526Y · Substantial damage NTSB DIA67F0104Accident · Minor injuriesClosedCessna 172 · New Bern, NCMay 20, 1967 · N2512Y · Substantial damage NTSB CHI67D0648Accident · No injuriesClosedCessna 172 · Plainville, ILMay 9, 1967 · N2181Y · Substantial damage NTSB OAK67D0294Accident · No injuriesClosedCessna 172 · Reno, NVApr 22, 1967 · N2133Y · Substantial damage NTSB MKC67D0455Accident · No injuriesClosedCessna 172 · Dodge Cntr, MNFeb 14, 1967 · N159AE · Substantial damage NTSB ANC67D0079Accident · No injuriesClosedCessna 172D · Wrangell, AKFeb 8, 1967 · N2658U · Substantial damage NTSB MIA67D0001Accident · Minor injuriesClosedCessna 172D · Ridgeland, SCJan 22, 1967 · N2732U · Substantial damage NTSB CHI67D0506Accident · No injuriesClosedCessna 172 · Port Clinton, OHJan 12, 1967 · N2144Y · Substantial damage NTSB MIA67D0359Accident · Minor injuriesClosedCessna 172 · Sanford, FLJan 7, 1967 · N2611U · Substantial damage NTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INDec 26, 1966 · N2558U · Substantial damage NTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHDec 19, 1966 · N2347U · Destroyed NTSB FTW67F0267Accident · Minor injuriesClosedCessna 172 · Fort Worth, TXNov 11, 1966 · N2320U · Substantial damage NTSB LAX67D0223Accident · Minor injuriesClosedCessna 172 · Crestline, CANov 6, 1966 · N2775U · Substantial damage NTSB OAK67D0154Accident · No injuriesClosedCessna 172D · Sunnyside, NVNov 5, 1966 · N2582Y · Substantial damage NTSB NYC67D0335Accident · No injuriesClosedCessna 172 · Flushing, NYOct 9, 1966 · N2549Y · Substantial damage NTSB NYC67F0262Accident · No injuriesClosedCessna 172D · Leesburg, VASep 24, 1966 · N2486Y · Substantial damage NTSB MIA67D0200Accident · No injuriesClosedCessna 172 · Mulberry, FLSep 24, 1966 · N2523U · Substantial damage NTSB SEA67D0132Accident · Minor injuriesClosedCessna 172 · Dutton, MTSep 4, 1966 · N2328U · Destroyed NTSB CHI67D0137Accident · No injuriesClosedCessna 172 · Muncie, INAug 6, 1966 · N2558U · Substantial damage NTSB LAX67D0066Accident · No injuriesClosedCessna 172 · Van Nuys, CAJul 15, 1966 · N2931U · Substantial damage NTSB CAN F0404Accident · No injuriesClosedCessna 172 · St.Laurent, CanadaJul 4, 1966 · N2382U · Substantial damage NTSB UNK66X0151Accident · No injuriesClosedCessna 172 · Parrsboro, CanadaJun 25, 1966 · N2474Y · Substantial damage NTSB MIA66F0519Accident · Minor injuriesClosedCessna 172 · Clemmons, NCMay 5, 1966 · N2815U · Substantial damage NTSB MKC66F0506Accident · No injuriesClosedCessna 172 · Lincoln, NEApr 13, 1966 · N2843U · Substantial damage NTSB NYC66A0112Accident · 2 fatalClosedCessna 172D · Princeton, WVApr 5, 1966 · N2486U · Destroyed NTSB DEN66F0293Accident · No injuriesClosedCessna 172 · Sandy, UTApr 3, 1966 · N2590Y · Substantial damage NTSB MKC66F0508Accident · Serious injuriesClosedCessna 172D · Kearney, NEApr 2, 1966 · N2407Y · Substantial damage NTSB MIA66D0514Accident · No injuriesClosedCessna 172 · Chamblee, GAMar 31, 1966 · N2526U · Substantial damage NTSB LAX66A0074Accident · 1 fatalClosedCessna 172D · Newhall, CAMar 27, 1966 · N2958U · Destroyed

Back to Cessna 172D