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 LAX67D0298Accident · No injuriesClosedCessna 172 · Daggett, CAFeb 4, 1967 · N7043A · Destroyed NTSB CHI67F0465Accident · No injuriesClosedCessna 172 · Roselle, ILFeb 3, 1967 · N6000A · Substantial damage NTSB CHI67D0499Accident · No injuriesClosedCessna 172 · Watertown, WIJan 20, 1967 · N8136B · Substantial damage NTSB NYC67D0430Accident · No injuriesClosedCessna 172 · Hampton, NHJan 7, 1967 · N8870B · Substantial damage NTSB MKC67A0041Accident · 1 fatalClosedCessna 172 · Spring Grove, MNJan 1, 1967 · N7378A · Destroyed NTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damage NTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMDec 19, 1966 · N5038A · Substantial damage NTSB LAX67D0248Accident · No injuriesClosedCessna 172 · Shafter, CADec 15, 1966 · N6228E · Substantial damage NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damage NTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · Destroyed NTSB FTW67D0334Accident · No injuriesClosedCessna 172 · Lubbock, TXNov 20, 1966 · N5717A · Substantial damage NTSB OAK67D0163Accident · No injuriesClosedCessna 172 · Wendover, NVNov 3, 1966 · N8613B · Substantial damage NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage NTSB FTW67D0298Accident · No injuriesClosedCessna 172 · Tahoka, TXOct 29, 1966 · N6191E · Substantial damage NTSB NYC67D0336Accident · No injuriesClosedCessna 172 · Charleston, WVOct 20, 1966 · N6272E · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB MKC67D0275Accident · No injuriesClosedCessna 172 · Anita, IAOct 9, 1966 · N8799B · Substantial damage NTSB OAK67D0109Accident · No injuriesClosedCessna 172 · Livermore, CAOct 2, 1966 · N5953A · Substantial damage NTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTOct 2, 1966 · N6188E · Substantial damage NTSB MKC67F0243Accident · No injuriesClosedCessna 172 · So.St.Paul, MNSep 26, 1966 · N8746B · Substantial damage NTSB OAK67F0096Accident · Serious injuriesClosedCessna 172 · Sparks, NVSep 25, 1966 · N6062A · 2 aircraft · Substantial damage NTSB LAX67F0165Accident · Serious injuriesClosedCessna 172 · Apple Valley, CASep 25, 1966 · N7034A · Destroyed NTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · Destroyed NTSB FTW67D0219Accident · No injuriesClosedCessna 172 · Hammond, LASep 23, 1966 · N5740A · Substantial damage NTSB NYC67D0207Accident · No injuriesClosedCessna 172 · Slocum, RISep 18, 1966 · N7062A · Substantial damage NTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage NTSB FTW67F0199Accident · Minor injuriesClosedCessna 172 · Yukon, OKSep 7, 1966 · N6686A · Substantial damage NTSB CHI67A0035Accident · 1 fatalClosedCessna 172 · Detroit, MISep 3, 1966 · N6725A · Destroyed NTSB MIA67D0175Accident · No injuriesClosedCessna 172 · Sun City, FLSep 1, 1966 · N7965B · Substantial damage NTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 25, 1966 · N6428E · Substantial damage NTSB MIA67A0024Accident · 3 fatalClosedCessna 172 · Flamingo, FLAug 12, 1966 · N6484E · Destroyed NTSB CHI67F0119Accident · Minor injuriesClosedCessna 172 · Shelbyville, KYAug 7, 1966 · N8590B · Substantial damage NTSB UNK66X0162Accident · No injuriesClosedCessna 172 · Suffolk, United KingdomAug 6, 1966 · N9188B · Substantial damage NTSB MIA67D0225Accident · No injuriesClosedCessna 172 · High Springs, FLAug 2, 1966 · N6102E · Substantial damage NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6332E · 2 aircraft · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6424B · 2 aircraft · Substantial damage NTSB OAK67A0013Accident · 2 fatalClosedCessna 172 · Orleans, CAJul 26, 1966 · N6229E · Destroyed NTSB SEA67A0006Accident · 3 fatalClosedCessna 172 · Cascade, IDJul 24, 1966 · N988TA · Substantial damage NTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMJul 23, 1966 · N8182B · Destroyed NTSB MKC67A0004Accident · 3 fatalClosedCessna 172 · Lorimor, IAJul 22, 1966 · N8823B · Destroyed NTSB CHI67F0118Accident · Serious injuriesClosedCessna 172 · Dekalb, ILJul 16, 1966 · N6917A · Substantial damage NTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damage NTSB CHI67F0084Accident · Minor injuriesClosedCessna 172 · Circleville, OHJul 4, 1966 · N6462B · Substantial damage NTSB OAK67D0038Accident · Serious injuriesClosedCessna 172 · Monache Medow, CAJul 2, 1966 · N8903B · Destroyed NTSB MIA67A0152Accident · 2 fatalClosedCessna 172 · Hatteras, NCJun 26, 1966 · N4106F · Destroyed NTSB CHI67D0080Accident · No injuriesClosedCessna 172 · Richland Cntr, WIJun 24, 1966 · N6202E · Destroyed

Back to Cessna 172