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 FTW67A0040Accident · 2 fatalClosedCessna 172F · Hempstead, TXSep 30, 1966 · N5306R · Destroyed NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB OAK67D0125Accident · Serious injuriesClosedCessna 172 · Alvarado, CASep 17, 1966 · N5388R · Destroyed NTSB NYC67D0253Accident · No injuriesClosedCessna 172 · Stratford, CTSep 10, 1966 · N8445U · Substantial damage NTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damage NTSB FTW67F0195Accident · No injuriesClosedCessna 172F · Lubbock, TXSep 2, 1966 · N7832U · Substantial damage NTSB CHI67D0196Accident · No injuriesClosedCessna 172 · Vestaburg, MIAug 26, 1966 · N8487U · Substantial damage NTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GAAug 23, 1966 · N8309U · Substantial damage NTSB LAX67D0068Accident · No injuriesClosedCessna 172F · Oceanside, CAAug 5, 1966 · N8846U · Substantial damage NTSB NYC67F0074Accident · No injuriesClosedCessna 172F · Reading, PAJul 24, 1966 · N8691U · Substantial damage NTSB FTW67F0110Accident · No injuriesClosedCessna 172 · Amarillo, TXJul 24, 1966 · N8368U · Substantial damage NTSB FTW67F0229Accident · No injuriesClosedCessna 172 · Grand Prairie, TXJul 21, 1966 · N8261U · Substantial damage NTSB NYC67F0387Accident · No injuriesClosedCessna 172F · Sharon, PAJul 9, 1966 · N5721R · Substantial damage NTSB NYC67F0066Accident · Serious injuriesClosedCessna 172F · Glens Falls, NYJul 2, 1966 · N643MA · Destroyed NTSB MKC67D0063Accident · No injuriesClosedCessna 172F · Kennett, MOJun 30, 1966 · N7871U · Substantial damage NTSB UNK66X0150Accident · No injuriesClosedCessna 172 · Perrault Flls, CanadaJun 22, 1966 · N8116U · Destroyed NTSB OAK67D0022Accident · No injuriesClosedCessna 172C · Petaluma, CAJun 18, 1966 · N7966U · Substantial damage NTSB FTW67F0022Accident · No injuriesClosedCessna 172F · Bethany, OKJun 5, 1966 · N5327R · Substantial damage NTSB MIA66F0563Accident · Minor injuriesClosedCessna 172 · Hendersonville, NCJun 2, 1966 · N5498R · Substantial damage NTSB LAX66D0368Accident · No injuriesClosedCessna 172 · Apple Valley, CAMay 29, 1966 · N8863U · Destroyed NTSB ANC66A0045Accident · 2 fatalClosedCessna 172F · Galena, AKMay 22, 1966 · N8809U · Destroyed NTSB MKC66D0585Accident · No injuriesClosedCessna 172 · Camdenton, MOMay 21, 1966 · N5597R · Substantial damage NTSB MIA66A0134Accident · 1 fatalClosedCessna 172F · Dothan, ALMay 16, 1966 · N5701R · Destroyed NTSB ANC67A0038Accident · 2 fatalClosedCessna 172F · Anchorage, AKApr 22, 1966 · N8690U · Destroyed NTSB MKC66F0563Accident · Minor injuriesClosedCessna 172 · Neodesha, KSApr 17, 1966 · N5638R · Substantial damage NTSB NYC66D0592Accident · No injuriesClosedCessna 172 · Reading, PAApr 16, 1966 · N8691U · Substantial damage NTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoApr 8, 1966 · N8305U · Substantial damage NTSB SEA66F0259Accident · No injuriesClosedCessna 172E · Anacortes, WAApr 5, 1966 · N3559S · Substantial damage NTSB MIA66F0487Accident · No injuriesClosedCessna 172 · Tchula, MSApr 5, 1966 · N5483R · Substantial damage NTSB CHI66D0696Accident · No injuriesClosedCessna 172 · New London, OHApr 3, 1966 · N5489R · Substantial damage NTSB NYC66F0593Accident · Minor injuriesClosedCessna 172F · Haverhill, MAMar 30, 1966 · N8556U · Substantial damage NTSB NYC66F0608Accident · Minor injuriesClosedCessna 172 · Roscoe, NYMar 29, 1966 · N8675U · Substantial damage NTSB MKC67D0001Accident · Minor injuriesClosedCessna 172F · Rich Fountain, MOMar 26, 1966 · N8703U · Substantial damage NTSB MIA66D0473Accident · No injuriesClosedCessna 172 · Ft Lauderdale, FLMar 25, 1966 · N8625U · Substantial damage NTSB MIA66D0496Accident · No injuriesClosedCessna 172 · Morristown, TNMar 13, 1966 · N7883U · Substantial damage NTSB MIA66D0456Accident · No injuriesClosedCessna 172 · Villa Rica, GAMar 9, 1966 · N8595U · Substantial damage NTSB MKC66F0494Accident · No injuriesClosedCessna 172F · Blodgett, MOMar 4, 1966 · N5634R · Substantial damage NTSB NYC66F0499Accident · No injuriesClosedCessna 172 · West Mifflin, PAMar 1, 1966 · N5439R · Substantial damage NTSB FTW66F0550Accident · No injuriesClosedCessna 172 · Amarillo, TXMar 1, 1966 · N8136U · Substantial damage NTSB MIA66A0095Accident · 1 fatalClosedCessna 172 · Portland, TNFeb 27, 1966 · N8177U · Destroyed NTSB MKC66F0495Accident · No injuriesClosedCessna 172 · S. St Paul, MNFeb 16, 1966 · N7824U · Substantial damage NTSB MIA66A0089Accident · 3 fatalClosedCessna 172F · Palmer, PRFeb 15, 1966 · N7848U · Destroyed NTSB CHI66D0562Accident · No injuriesClosedCessna 172 · Mt Vernon, OHFeb 9, 1966 · N5660R · Substantial damage NTSB OAK66D0210Accident · No injuriesClosedCessna 172 · Sacramento, CAFeb 7, 1966 · N5571R · Substantial damage NTSB MIA66F0416Accident · Minor injuriesClosedCessna 172 · San Juan, PRFeb 5, 1966 · N8523U · Substantial damage NTSB OAK66A0031Accident · 2 fatalClosedCessna 172F · Livermore, CAFeb 4, 1966 · N8184U · Destroyed NTSB DEN66D0233Accident · Serious injuriesClosedCessna 172 · Springervile, AZJan 31, 1966 · N8263U · Destroyed NTSB NYC66D0481Accident · No injuriesClosedCessna 172 · Canastota, NYJan 27, 1966 · N5470R · Substantial damage NTSB LAX66F0250Accident · No injuriesClosedCessna 172 · Ontario, CAJan 16, 1966 · N5466R · Substantial damage NTSB NYC66F0440Accident · No injuriesClosedCessna 172F · Baltimore, MDJan 8, 1966 · N7950U · Substantial damage

Back to Cessna 172F