Skip to content

NTSB investigations · 1,097

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 ('2072402') 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 ('2072402')
  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 ('2072402')
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 MKC77DCQ06Accident · Minor injuriesClosedCessna 172 · Fort Scott, KSNov 16, 1976 · N6640A · Substantial damage NTSB FTW77KQG04Accident · Serious injuriesClosedCessna 172 · Petersburg, TXNov 12, 1976 · N8267B · Destroyed NTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNov 9, 1976 · N5789A · Destroyed NTSB SEA77FTI02Accident · No injuriesClosedCessna 172 · Whitefish, MTNov 7, 1976 · N8746B · Substantial damage NTSB LAX77FUG07Accident · No injuriesClosedCessna 172 · Perris, CANov 7, 1976 · N5794A · Substantial damage NTSB OAK77DVD04Accident · No injuriesClosedCessna 172 · Petaluma, CANov 5, 1976 · N4185F · Substantial damage NTSB ANC77DA002Accident · No injuriesClosedCessna 172 · Lower Kalskag, AKOct 18, 1976 · N9123B · Substantial damage NTSB MIA76DLG39Accident · No injuriesClosedCessna 172 · Neeses, SCAug 29, 1976 · N6482E · Substantial damage NTSB FTW76FPH06Accident · No injuriesClosedCessna 172 · Ola, ARAug 27, 1976 · N6800A · Substantial damage NTSB CHI76FET48Accident · No injuriesClosedCessna 172 · Griffith, INAug 17, 1976 · N5750A · Substantial damage NTSB FTW76DPG94Accident · No injuriesClosedCessna 172 · Augusta, ARAug 5, 1976 · N7468A · Substantial damage NTSB SEA76FYC62Accident · Serious injuriesClosedCessna 172M · Albany, ORJul 5, 1976 · N1381U · Substantial damage NTSB IAD76FIG19Accident · Minor injuriesClosedCessna 172 · Laurel, MDJun 26, 1976 · N6315E · Substantial damage NTSB IAD76FID27Accident · Serious injuriesClosedCessna 172 · Suffolk, VAMay 31, 1976 · N5917A · Substantial damage NTSB LAX76AL075Accident · 1 fatalClosedCessna 172E · Kingman, AZMay 15, 1976 · N3658R · Destroyed NTSB FTW76AF094Accident · 1 fatalClosedCessna 172 · Dyess, ARMay 11, 1976 · N5187A · Substantial damage NTSB SEA76FYE39Accident · Serious injuriesClosedCessna 172 · Martha Lake, WAMay 9, 1976 · N8597B · Substantial damage NTSB DEN76FTE66Accident · Minor injuriesClosedCessna 172 · Burlington, COMay 9, 1976 · N8387B · Substantial damage NTSB FTW76FPG47Accident · No injuriesClosedCessna 172 · Brinkley, ARApr 26, 1976 · N8697B · Substantial damage NTSB MKC76FCA22Accident · Minor injuriesClosedCessna 172 · Shelbyville, MOApr 24, 1976 · N8507B · Substantial damage NTSB FTW76DRA36Accident · No injuriesClosedCessna 150M · Sugarland, TXApr 21, 1976 · N6605A · Substantial damage NTSB DEN76FQA41Accident · Serious injuriesClosedCessna 172 · Albuquerque, NMApr 19, 1976 · N6741A · Substantial damage NTSB SEA76A5043Accident · 1 fatalClosedCessna 172 · Sweet Home, ORApr 10, 1976 · N7075T · Destroyed NTSB LAX76AL053Accident · 4 fatalClosedCessna 172 · Prescott, AZFeb 13, 1976 · N84011 · Destroyed NTSB CHI76DEA27Accident · No injuriesClosedCessna 172 · Kokomo, INFeb 9, 1976 · N4104F · Destroyed NTSB CHI76FEC21Accident · No injuriesClosedCessna 172 · Pinckney, MIJan 18, 1976 · N4154F · Substantial damage NTSB MIA76DLG23Accident · No injuriesClosedCessna 172 · Blair, SCOct 25, 1975 · N6439E · Substantial damage NTSB LAX76AL027Accident · 2 fatalClosedCessna 172 · Rialto, CAOct 21, 1975 · N5963A · Destroyed NTSB FTW76FRJ11Accident · Minor injuriesClosedCessna 172 · Lake Hawkins, TXOct 16, 1975 · N7295A · Substantial damage NTSB LAX76DUJ40Accident · No injuriesClosedCessna 172 · Ft.Grant, AZSep 13, 1975 · N9154B · Substantial damage NTSB DEN76FTM06Accident · No injuriesClosedCessna 172 · Beaver, UTAug 26, 1975 · N7954B · Substantial damage NTSB MKC76FTG07Accident · No injuriesClosedCessna 172 · Turtle Lake, NDAug 19, 1975 · N7094T · Substantial damage NTSB LAX7LFUJ11Accident · Serious injuriesClosedCessna 172 · Payson, AZAug 16, 1975 · N921CR · Substantial damage NTSB MIA76DLD10Accident · No injuriesClosedCessna 172 · Bushnell, FLAug 12, 1975 · N9119B · Substantial damage NTSB FTW75AF075Accident · 4 fatalClosedCessna 172 · Plainview, TXJun 26, 1975 · N7086T · Destroyed NTSB MIA75DKQ35Accident · No injuriesClosedCessna 172 · Forest, MSJun 14, 1975 · N4125F · Substantial damage NTSB FTW75FPJ22Accident · No injuriesClosedCessna 172 · Ada, OKMay 3, 1975 · N6035A · Substantial damage NTSB IAD75DKM27Accident · No injuriesClosedCessna 172 · Liberty, NCApr 23, 1975 · N7095T · Substantial damage NTSB FTW75FPA22Accident · Minor injuriesClosedCessna 172 · Corsicana, TXMar 8, 1975 · N4095F · Substantial damage NTSB MIA75FKJ42Accident · No injuriesClosedCessna 172 · Columbia, ALFeb 8, 1975 · N6238E · Substantial damage NTSB SEA75DYG19Accident · No injuriesClosedCessna 172 · Colville, WAFeb 2, 1975 · N7230A · Substantial damage NTSB NYC75FFA25Accident · No injuriesClosedCessna 172 · Malone, NYDec 28, 1974 · N35531 · Substantial damage NTSB NYC75DHA25Accident · No injuriesClosedCessna 172 · Manville, NJDec 28, 1974 · N6966A · Substantial damage NTSB NYC75AN074Accident · 3 fatalClosedCessna 172 · Philipsburg, PADec 12, 1974 · N5868A · Destroyed NTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damage NTSB OAK75DVG40Accident · No injuriesClosedCessna 172 · Orland, CADec 8, 1974 · N5722A · Substantial damage NTSB MIA75OM004Accident · Minor injuriesClosedCessna 172 · St Barthelemy, GuadeloupeDec 4, 1974 · N6170E · Substantial damage NTSB SEA75FYG11Accident · No injuriesClosedCessna 172 · Richland, WANov 2, 1974 · N7143T · Substantial damage NTSB IAD75AIJ11Accident · No injuriesClosedCessna 172 · Hazelgreen, WVOct 24, 1974 · N7242A · Destroyed NTSB NYC75AN044Accident · 1 fatalClosedCessna 172 · Anglesea, NJSep 28, 1974 · N4250F · Destroyed

Back to Cessna 172