Skip to content

NTSB investigations · 1,699

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 ('2072418') 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 ('2072418')
  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 ('2072418')
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 SEA77DYG03Accident · No injuriesClosedCessna 172M · Benge, WASep 9, 1976 · N12772 · Substantial damage NTSB NYC76AN124Accident · 4 fatalClosedCessna 172M · N Amityville, NYSep 6, 1976 · N1382U · Destroyed NTSB LAX76FUQ50Accident · Minor injuriesClosedCessna 172M · Santa Susana, CASep 4, 1976 · N91763 · Substantial damage NTSB CHI76FEC59Accident · No injuriesClosedCessna 172M · Pontiac, MISep 4, 1976 · N73566 · Substantial damage NTSB LAX76DUK04Accident · No injuriesClosedCessna 150 · Prescott, AZAug 28, 1976 · N12944 · Substantial damage NTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LAAug 28, 1976 · N80347 · Destroyed NTSB CHI76DEP46Accident · Serious injuriesClosedCessna 172 · Dodgeville, WIAug 28, 1976 · N9626V · Substantial damage NTSB MKC76FCA42Accident · Minor injuriesClosedCessna 172M · Centerville, MOAug 21, 1976 · N9230H · Destroyed NTSB NYC76DNC64Accident · Minor injuriesClosedCessna 172 · Andover, MEAug 15, 1976 · N13325 · Destroyed NTSB CHI76FEE70Accident · Minor injuriesClosedCessna 172M · Antioch, ILAug 14, 1976 · N673PJ · Substantial damage NTSB SEA76AS070Accident · 4 fatalClosedCessna 172N · Enumclaw, WAAug 11, 1976 · N20083 · Destroyed NTSB MIA76FKQ43Accident · No injuriesClosedCessna 172M · Holly Bluff, MSAug 11, 1976 · N1602V · Substantial damage NTSB OAK76DVH03Accident · No injuriesClosedCessna 172 · Franklin, CAAug 9, 1976 · N64413 · Substantial damage NTSB FTW76AF113Accident · 1 fatalClosedCessna 172 · Baker, LAAug 8, 1976 · N12697 · Destroyed NTSB CHI76FEC53Accident · No injuriesClosedCessna 172 · Ann Arbor, MIAug 8, 1976 · N91961 · Substantial damage NTSB DEN76FTM43Accident · No injuriesClosedCessna 172M · Cedar City, UTAug 7, 1976 · N5285H · Substantial damage NTSB CHI76FEC52Accident · No injuriesClosedCessna 172M · Westland, MIAug 7, 1976 · N1133U · Substantial damage NTSB CHI76FEV53Accident · No injuriesClosedCessna 172M · Jerseyville, ILJul 26, 1976 · N13381 · Substantial damage NTSB DEN76DTE83Accident · No injuriesClosedCessna 172 · Limon, COJul 17, 1976 · N20545 · Substantial damage NTSB MKC76DCJ49Accident · No injuriesClosedCessna 172 · Mccook, NEJul 15, 1976 · N64294 · Substantial damage NTSB CHI76FEI34Accident · No injuriesClosedCessna 172 · Sandusky, OHJul 13, 1976 · N9591V · Substantial damage NTSB FTW76FPD49Accident · Minor injuriesClosedCessna 172 · Smithfield, TXJul 11, 1976 · N80296 · Substantial damage NTSB FTW76FPA27Accident · No injuriesClosedCessna 172 · Waco, TXJul 7, 1976 · N12585 · Substantial damage NTSB NYC76AN109Accident · 1 fatalClosedCessna 172 · White Plains, NYJul 6, 1976 · N13485 · Destroyed NTSB MIA76DKG81Accident · No injuriesClosedCessna 172 · Chauncey, GAJul 2, 1976 · N1707V · Substantial damage NTSB MIA76DLD65Accident · No injuriesClosedCessna 172 · Daytona Beach, FLJun 23, 1976 · N9582H · Substantial damage NTSB OAK76DVG90Accident · No injuriesClosedCessna 172 · Grass Valley, CAJun 18, 1976 · N1557V · Substantial damage NTSB FTW76AF103Accident · 3 fatalClosedCessna 172M · Sperry, OKJun 18, 1976 · N13132 · 2 aircraft · Destroyed NTSB CHI76FEV44Accident · No injuriesClosedCessna 172 · Pinckneyville, ILJun 17, 1976 · N13209 · Substantial damage NTSB CHI76AC066Accident · 3 fatalClosedCessna 172M · Shelbyville, ILMay 31, 1976 · N80946 · Destroyed NTSB FTW76DRJ28Accident · No injuriesClosedCessna 172 · Many, LAMay 30, 1976 · N13441 · Substantial damage NTSB LAX76AL082Accident · 1 fatalClosedCessna 172M · Corona, CAMay 29, 1976 · N12227 · Destroyed NTSB FTW76DPG58Accident · No injuriesClosedCessna 172 · Manila, ARMay 29, 1976 · N5248R · Substantial damage NTSB DEN76DTM34Accident · No injuriesClosedCessna 172M · Manila, UTMay 29, 1976 · N80976 · Substantial damage NTSB DEN76DTE74Accident · No injuriesClosedCessna 172M · Colorado Spgs, COMay 27, 1976 · N9719V · Substantial damage NTSB CHI76FEK16Accident · No injuriesClosedCessna 172 · Sidney, OHMay 26, 1976 · N131MT · Substantial damage NTSB FTW76DPG56Accident · No injuriesClosedCessna 172 · Bald Knob, ARMay 25, 1976 · N19870 · Substantial damage NTSB SEA76FYC53Accident · No injuriesClosedCessna 172 · Aurora, ORMay 24, 1976 · N5375R · Substantial damage NTSB MIA76AM086Accident · 2 fatalClosedCessna 172M · Lavonia, GAMay 24, 1976 · N9941Q · Destroyed NTSB CHI76DEE60Accident · No injuriesClosedCessna 172M · Chicago, ILMay 22, 1976 · N5162R · Substantial damage NTSB SEA76DYC46Accident · No injuriesClosedCessna 172M · Yamhill, ORMay 15, 1976 · N13252 · Substantial damage NTSB DEN76FTE73Accident · No injuriesClosedCessna 172 · Broomfield, COMay 14, 1976 · N9208H · Substantial damage NTSB OAK76DVG74Accident · No injuriesClosedCessna 172M · Lake Berryessa, CAMay 3, 1976 · N20086 · Substantial damage NTSB NYC76FHJ21Accident · No injuriesClosedCessna 172 · Islip, NYMay 2, 1976 · N4379R · Substantial damage NTSB LAX76DUG49Accident · No injuriesClosedCessna 172 · Mecca, CAMay 2, 1976 · N64156 · Substantial damage NTSB FTW76DRA33Accident · No injuriesClosedCessna 172 · Huntsville, TXApr 30, 1976 · N12814 · Substantial damage NTSB FTW76AF092Accident · 1 fatalClosedCessna 172M · Kirkland, TXApr 29, 1976 · N21496 · Destroyed NTSB NYC76DFJ22Accident · No injuriesClosedCessna 172 · Niagara Falls, NYApr 23, 1976 · N64541 · Substantial damage NTSB FTW76DRJ22Accident · No injuriesClosedCessna 172M · Alexandria, LAApr 21, 1976 · N80327 · Substantial damage NTSB MKC76FCQ43Accident · No injuriesClosedCessna 172 · Meade, KSApr 16, 1976 · N13013 · Substantial damage

Back to Cessna 172M