Skip to content

NTSB investigations · 455

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 ('2072412') 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 ('2072412')
  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 ('2072412')
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 FTW68D0102Accident · No injuriesClosedCessna 172 · Freemason Isle, LAAug 2, 1967 · N3679S · Substantial damage NTSB CHI68F0150Accident · No injuriesClosedCessna 172E · Hobart, INJul 20, 1967 · N7727U · Substantial damage NTSB MKC68D0080Accident · No injuriesClosedCessna 172E · Oskaloosa, IAJul 15, 1967 · N3748S · 2 aircraft · Substantial damage NTSB LAX68F0054Accident · No injuriesClosedCessna 172 · Arcadia, CAJul 2, 1967 · N3879S · Substantial damage NTSB FTW68D0082Accident · Minor injuriesClosedCessna 172 · Huttig, ARJul 2, 1967 · N3624S · Substantial damage NTSB FTW68D0062Accident · No injuriesClosedCessna 172 · Griffithville, ARJul 1, 1967 · N3620S · Substantial damage NTSB NYC67F0671Accident · No injuriesClosedCessna 172 · Caribou, MEMay 27, 1967 · N3738S · Substantial damage NTSB FTW67D0643Accident · No injuriesClosedCessna 172 · Earle, ARMay 27, 1967 · N3867S · Substantial damage NTSB LAX67D0390Accident · No injuriesClosedCessna 172 · Murrieta, CAMay 7, 1967 · N5504T · Substantial damage NTSB SEA67F0327Accident · Minor injuriesClosedCessna 172E · Vancouver, WAApr 17, 1967 · N7705U · Substantial damage NTSB NYC67D0624Accident · No injuriesClosedCessna 172E · Block Island, RIMar 25, 1967 · N3500S · Substantial damage NTSB MIA67A0096Accident · 2 fatalClosedCessna 172E · Donalsonville, GAMar 25, 1967 · N7730U · Destroyed NTSB LAX67F0333Accident · 1 fatalClosedCessna 172 · Phoenix, AZMar 9, 1967 · N3959S · Substantial damage NTSB FTW67F0479Accident · No injuriesClosedCessna 172 · Hughes, ARFeb 22, 1967 · N7749U · Substantial damage NTSB LAX67F0273Accident · No injuriesClosedCessna 172 · Van Nuys, CAFeb 11, 1967 · N5504T · Substantial damage NTSB SEA67D0238Accident · No injuriesClosedCessna 172 · Pasco, WAJan 29, 1967 · N3034U · Substantial damage NTSB MKC67F0438Accident · No injuriesClosedCessna 172 · Blaine, MNJan 28, 1967 · N3024U · Substantial damage NTSB FTW67F0423Accident · No injuriesClosedCessna 172 · Fort Worth, TXJan 26, 1967 · N3691S · Substantial damage NTSB NYC67F0419Accident · No injuriesClosedCessna 172E · Lakeville, PAJan 8, 1967 · N3790S · Substantial damage NTSB NYC67D0465Accident · No injuriesClosedCessna 172 · Middletown, NYJan 2, 1967 · N5506T · Substantial damage NTSB FTW67D0400Accident · No injuriesClosedCessna 172 · Lawton, OKJan 2, 1967 · N3693S · Substantial damage NTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJDec 30, 1966 · N5563T · Substantial damage NTSB OAK67F0209Accident · No injuriesClosedCessna 172 · Bishop, CADec 22, 1966 · N3579S · Destroyed NTSB MKC67F0394Accident · Serious injuriesClosedCessna 172E · Farmington, MODec 19, 1966 · N5732T · Destroyed NTSB CHI67D0418Accident · Minor injuriesClosedCessna 172 · Kasbeer, ILNov 26, 1966 · N3588S · Substantial damage NTSB MIA67D0311Accident · No injuriesClosedCessna 172 · Ft-Bassinger, FLNov 4, 1966 · N3582S · Substantial damage NTSB MIA67F0212Accident · No injuriesClosedCessna 172E · Tampa, FLSep 20, 1966 · N3685S · Substantial damage NTSB MKC67F0257Accident · No injuriesClosedCessna 172E · St.Charles, MOSep 5, 1966 · N7730U · Substantial damage NTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MOAug 28, 1966 · N3915S · Destroyed NTSB NYC67F0239Accident · No injuriesClosedCessna 172 · Neptune, NJAug 18, 1966 · N5414T · Substantial damage NTSB CHI67D0146Accident · No injuriesClosedCessna 172 · Reed City, MIJul 31, 1966 · N5407T · Substantial damage NTSB LAX67D0082Accident · Minor injuriesClosedCessna 172 · Santa Ynez, CAJul 30, 1966 · N3946S · Substantial damage NTSB NYC67D0105Accident · No injuriesClosedCessna 172 · Madison, CTJul 17, 1966 · N3597S · Substantial damage NTSB OAK67F0013Accident · Serious injuriesClosedCessna 172E · Vacaville, CAJun 26, 1966 · N3911S · Substantial damage NTSB OAK67F0027Accident · No injuriesClosedCessna 172E · Fresno, CAJun 12, 1966 · N5386T · Substantial damage NTSB FTW67F0013Accident · No injuriesClosedCessna 172 · Hackberry, LAJun 12, 1966 · N3719S · Substantial damage NTSB LAX66A0093Accident · 2 fatalClosedCessna 172E · Wendover, NVMay 26, 1966 · N3887S · Destroyed NTSB MIA66A0128Accident · 2 fatalClosedCessna 172E · Clearwater, FLMay 5, 1966 · N3907S · Destroyed NTSB LAX66D0340Accident · No injuriesClosedCessna 172 · Adelanto, CAApr 17, 1966 · N5647T · Substantial damage NTSB CHI66F0685Accident · No injuriesClosedCessna 172E · Beaver Dam, WIApr 10, 1966 · N5361T · Substantial damage NTSB CHI66D0713Accident · Minor injuriesClosedCessna 172E · Albany, KYApr 7, 1966 · N5737T · Destroyed NTSB MKC66D0490Accident · No injuriesClosedCessna 172 · Moberly, MOApr 2, 1966 · N5652T · Substantial damage NTSB MKC66D0527Accident · No injuriesClosedCessna 172 · Creston, IAMar 31, 1966 · N3940S · Substantial damage NTSB MIA66D0503Accident · No injuriesClosedCessna 172 · Dalton, GAMar 31, 1966 · N3792S · Substantial damage NTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCMar 27, 1966 · N5340T · Substantial damage NTSB FTW66D0583Accident · Minor injuriesClosedCessna 172 · Randlett, OKMar 26, 1966 · N3773S · Substantial damage NTSB DEN66F0253Accident · No injuriesClosedCessna 172E · Denver, COMar 17, 1966 · N5718T · Destroyed NTSB FTW66D0525Accident · No injuriesClosedCessna 172 · Oklahoma City, OKMar 5, 1966 · N5747T · Substantial damage NTSB CHI66F0621Accident · No injuriesClosedCessna 172E · E Alton, ILMar 4, 1966 · N3501S · Substantial damage NTSB LAX66F0252Accident · No injuriesClosedCessna 172 · Bakersfield, CAFeb 22, 1966 · N5720T · Substantial damage

Back to Cessna 172E