Skip to content

NTSB investigations · 563

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 ('2072414') 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 ('2072414')
  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 ('2072414')
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 CHI68D0518Accident · Minor injuriesClosedCessna 172 · Painesville, OHNov 10, 1967 · N5465R · Substantial damage NTSB FTW68F0302Accident · Minor injuriesClosedCessna 172F · Waco, TXOct 23, 1967 · N7877U · Substantial damage NTSB MIA68F0196Accident · Minor injuriesClosedCessna 172E · Murfreesboro, TNSep 29, 1967 · N8693U · Substantial damage NTSB NYC68F0261Accident · No injuriesClosedCessna 172 · Ogdensburg, NYSep 2, 1967 · N8345U · Substantial damage NTSB MKC68A0016Accident · 2 fatalClosedCessna 172F · Chesterfield, MOAug 30, 1967 · N8621U · Destroyed NTSB NYC68I0033Incident · No injuriesClosedCessna 172 · Flushing, NYAug 28, 1967 · N8819U · Substantial damage NTSB MIA68F0105Accident · No injuriesClosedCessna 172 · Tampa, FLAug 7, 1967 · N5366R · Substantial damage NTSB NYC68D0083Accident · No injuriesClosedCessna 172 · Newburyport, MAAug 6, 1967 · N5358R · Substantial damage NTSB NYC68A0024Accident · 5 fatalClosedCessna 172F · Laconia, NHAug 6, 1967 · N5507R · 2 aircraft · Destroyed NTSB FTW68S0001Incident · 1 fatalClosedCessna 172 · Lk.Jackson, TXJul 17, 1967 · N5577R · No damage NTSB MKC68D0121Accident · Minor injuriesClosedCessna 172 · Forest City, MOJul 11, 1967 · N7860U · Substantial damage NTSB UNK67X0133Accident · 1 fatalClosedCessna 172 · Holland Ldg, CanadaJul 1, 1967 · N8706U · Substantial damage NTSB OAK68D0085Accident · No injuriesClosedCessna 172 · Eureka, NVJun 25, 1967 · N172EF · Substantial damage NTSB MIA68D0047Accident · No injuriesClosedCessna 172 · St Thomas, VIJun 22, 1967 · N8624U · Substantial damage NTSB FTW68D0015Accident · No injuriesClosedCessna 172 · Ponca City, OKJun 17, 1967 · N7982U · Substantial damage NTSB NYC68F0020Accident · No injuriesClosedCessna 172F · East Hanover, NJJun 11, 1967 · N8808U · Substantial damage NTSB FTW67F0650Accident · No injuriesClosedCessna 172 · Freemason Isle, LAJun 11, 1967 · N7983U · Substantial damage NTSB FTW67A0113Accident · 1 fatalClosedCessna 172F · Houma, LAMay 30, 1967 · N8806U · Substantial damage NTSB OAK68D0013Accident · No injuriesClosedCessna 172 · Oakland, CAMay 23, 1967 · N8185U · Substantial damage NTSB CHI68D0471Accident · No injuriesClosedCessna 172F · Bloomington, ILMay 19, 1967 · N5327R · Substantial damage NTSB OAK68D0152Accident · No injuriesClosedCessna 172 · Las Vegas, NVMay 10, 1967 · N8185U · Substantial damage NTSB FTW67F0591Accident · Serious injuriesClosedCessna 172 · Haynesville, LAMay 3, 1967 · N7895U · Destroyed NTSB SEA67F0343Accident · Serious injuriesClosedCessna 172F · Beaverton, ORApr 23, 1967 · N8196U · Substantial damage NTSB MIA67A0110Accident · 1 fatalClosedCessna 172F · Jackson, SCApr 23, 1967 · N5504R · Substantial damage NTSB CHI67F0625Accident · No injuriesClosedCessna 172 · Three Oaks, MIApr 21, 1967 · N8457U · Substantial damage NTSB LAX67D0394Accident · No injuriesClosedCessna 172 · Apple Valley, CAApr 19, 1967 · N5396R · Substantial damage NTSB CHI67D0616Accident · No injuriesClosedCessna 172 · Lodi, OHApr 16, 1967 · N8834U · Substantial damage NTSB NYC67F0589Accident · No injuriesClosedCessna 172 · Plainville, CTApr 9, 1967 · N5519R · 2 aircraft · Substantial damage NTSB DEN67F0261Accident · Minor injuriesClosedCessna 172 · Cheyenne, WYMar 27, 1967 · N8865U · Substantial damage NTSB MIA67D0542Accident · No injuriesClosedCessna 172 · Lincolnton, GAMar 25, 1967 · N5504R · Substantial damage NTSB CHI67F0603Accident · Minor injuriesClosedCessna 172F · Burlington, WIMar 18, 1967 · N5436R · Substantial damage NTSB OAK67D0276Accident · Serious injuriesClosedCessna 172 · Carmel, CAMar 16, 1967 · N8166U · Substantial damage NTSB MKC67D0467Accident · No injuriesClosedCessna 172 · Stanton, MNFeb 24, 1967 · N5403R · Substantial damage NTSB LAX67D0313Accident · No injuriesClosedCessna 172 · El Monte, CAFeb 17, 1967 · N8166U · Substantial damage NTSB MKC67D0537Accident · No injuriesClosedCessna 172F · Bridgeton, MOFeb 13, 1967 · N8164U · Substantial damage NTSB CHI67D0547Accident · No injuriesClosedCessna 172 · Youngstown, OHFeb 12, 1967 · N5534R · Substantial damage NTSB FTW67F0441Accident · No injuriesClosedCessna 172 · Oklahoma Cy, OKFeb 5, 1967 · N7970U · Substantial damage NTSB CHI67D0514Accident · No injuriesClosedCessna 172 · Chicago, ILFeb 4, 1967 · N5443R · Substantial damage NTSB MIA67F0379Accident · No injuriesClosedCessna 172F · Port Gibson, MSJan 30, 1967 · N8594U · Substantial damage NTSB NYC67D0472Accident · Minor injuriesClosedCessna 172 · Trumbull, CTJan 22, 1967 · N8280U · Substantial damage NTSB FTW67F0422Accident · No injuriesClosedCessna 172 · Buchanon Dam, TXJan 21, 1967 · N7921U · Substantial damage NTSB OAK67F0227Accident · Serious injuriesClosedCessna 172F · Monterey, CAJan 16, 1967 · N5650R · Destroyed NTSB LAX67D0271Accident · No injuriesClosedCessna 172 · Agua Dulce, CAJan 15, 1967 · N5609R · Substantial damage NTSB FTW67F0366Accident · No injuriesClosedCessna 172 · Dallas, TXJan 6, 1967 · N8627U · Substantial damage NTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VADec 30, 1966 · N8556U · Substantial damage NTSB LAX67D0221Accident · No injuriesClosedCessna 172 · Mojave, CADec 7, 1966 · N8848U · Substantial damage NTSB MKC67D0352Accident · No injuriesClosedCessna 172 · Bixby, MONov 21, 1966 · N5607R · Destroyed NTSB MIA67D0313Accident · No injuriesClosedCessna 172 · Opa Locka, FLNov 10, 1966 · N5359R · Substantial damage NTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALOct 19, 1966 · N5372R · Substantial damage NTSB OAK67A0041Accident · 3 fatalClosedCessna 172F · Woodford, CAOct 2, 1966 · N5655R · Destroyed

Back to Cessna 172F