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 MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MOJun 17, 1966 · N7287A · Substantial damage NTSB OAK66A0056Accident · 2 fatalClosedCessna 172 · Seigler Sprgs, CAJun 11, 1966 · N7204A · Destroyed NTSB FTW67D0037Accident · No injuriesClosedCessna 172 · Alba, TXJun 11, 1966 · N5621A · Substantial damage NTSB SEA66D0290Accident · No injuriesClosedCessna 172 · Camas Prairi, MTJun 5, 1966 · N5008A · Substantial damage NTSB MIA67F0158Accident · Serious injuriesClosedCessna 172 · Palatka, FLJun 4, 1966 · N4139F · Substantial damage NTSB NYC67F0002Accident · Minor injuriesClosedCessna 172 · Northfield, CTJun 3, 1966 · N8790B · Substantial damage NTSB MKC67D0069Accident · No injuriesClosedCessna 172 · St.Charles, MOMay 28, 1966 · N5643A · Substantial damage NTSB FTW66A0109Accident · 1 fatalClosedCessna 172 · Boyce, LAMay 28, 1966 · N5886A · Destroyed NTSB NYC66D0705Accident · No injuriesClosedCessna 172 · Penn Yan, NYMay 27, 1966 · N6197E · Substantial damage NTSB CHI66D0777Accident · Minor injuriesClosedCessna 172 · Middleton, WIMay 26, 1966 · N8795B · Substantial damage NTSB SEA66A0060Accident · 3 fatalClosedCessna 172 · Metaline Fls, WAMay 24, 1966 · N7230A · Substantial damage NTSB NYC66A0714Accident · Serious injuriesClosedCessna 172 · Clinton, MDMay 20, 1966 · N6117E · Destroyed NTSB MKC66D0545Accident · No injuriesClosedCessna 172 · Worthington, MNMay 19, 1966 · N7040T · Substantial damage NTSB SEA66D0265Accident · No injuriesClosedCessna 172 · Havre, MTMay 12, 1966 · N7285A · Substantial damage NTSB DEN67D0013Accident · No injuriesClosedCessna 172 · Sierra Vista, AZMay 11, 1966 · N9180Z · Substantial damage NTSB SEA67F0041Accident · Serious injuriesClosedCessna 172 · Ocean Shores, WAMay 8, 1966 · N5949A · Destroyed NTSB OAK66D0289Accident · No injuriesClosedCessna 172 · Tracy, CAMay 7, 1966 · N5023A · Substantial damage NTSB CHI66F0720Accident · No injuriesClosedCessna 172 · Dimondale, MIMay 7, 1966 · N6428B · Substantial damage NTSB CHI66D0722Accident · No injuriesClosedCessna 172 · Leonidas, MIMay 2, 1966 · N8363B · Substantial damage NTSB CHI66D0746Accident · No injuriesClosedCessna 172 · Angola, INApr 29, 1966 · N5999A · Substantial damage NTSB DEN66D0322Accident · No injuriesClosedCessna 172 · Elroy, AZApr 24, 1966 · N4170F · Substantial damage NTSB FTW66D0623Accident · No injuriesClosedCessna 172 · Freemason Is, LAApr 8, 1966 · N7967B · Substantial damage NTSB NYC66D0605Accident · No injuriesClosedCessna 172 · Taylorsville, MDApr 3, 1966 · N7046A · Substantial damage NTSB MKC66D0532Accident · No injuriesClosedCessna 172 · Faribault, MNMar 31, 1966 · N8264B · Substantial damage NTSB MKC66D0531Accident · Minor injuriesClosedCessna 172 · Minneapolis, MNMar 31, 1966 · N8159B · Substantial damage NTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damage NTSB DEN66F0265Accident · No injuriesClosedCessna 172 · Kearns, UTMar 24, 1966 · N8307B · Substantial damage NTSB FTW66D0528Accident · No injuriesClosedCessna 172 · Franklin, LAMar 12, 1966 · N5757A · Substantial damage NTSB MKC66F0486Accident · No injuriesClosedCessna 172 · Dexter, MNMar 8, 1966 · N5100A · Substantial damage NTSB DEN66D0313Accident · No injuriesClosedCessna 172 · San Simon, AZFeb 8, 1966 · N5942A · Substantial damage NTSB NYC66D0532Accident · No injuriesClosedCessna 172 · Warwick, NYFeb 6, 1966 · N8508B · Substantial damage NTSB FTW66F0493Accident · No injuriesClosedCessna 172 · Amarillo, TXJan 31, 1966 · N6364E · Substantial damage NTSB DEN66D0241Accident · No injuriesClosedCessna 172 · Nunn, COJan 30, 1966 · N6221E · Substantial damage NTSB NYC66D0468Accident · No injuriesClosedCessna 172 · Emlenton, PAJan 29, 1966 · N6258E · Substantial damage NTSB LAX66D0283Accident · No injuriesClosedCessna 172 · Las Vegas, NVJan 23, 1966 · N5380R · Substantial damage NTSB CHI66A0063Accident · 5 fatalClosedCessna 172 · Rockton, ILJan 23, 1966 · N5735A · 2 aircraft · Destroyed NTSB LAX66F0320Accident · No injuriesClosedCessna 172 · Las Vegas, NVJan 18, 1966 · N5773A · Substantial damage NTSB CHI66F0513Accident · Minor injuriesClosedCessna 172 · Greenville, MIJan 16, 1966 · N7053A · Substantial damage NTSB FTW66D0467Accident · No injuriesClosedCessna 172 · Conway, ARJan 9, 1966 · N6876A · Substantial damage NTSB NYC66F0427Accident · No injuriesClosedCessna 172 · Lewiston, MEDec 23, 1965 · N8197B · Substantial damage NTSB FTW66F0453Accident · No injuriesClosedCessna 172 · Houston, TXDec 9, 1965 · N8935B · Substantial damage NTSB MIA66A0062Accident · 1 fatalClosedCessna 172 · St Marys, GANov 27, 1965 · N6232E · Destroyed NTSB DEN66F0156Accident · No injuriesClosedCessna 172 · Usaf Academy, CONov 14, 1965 · N346TC · Substantial damage NTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNov 13, 1965 · N6225E · Substantial damage NTSB CHI66D0431Accident · No injuriesClosedCessna 172 · Canton, OHNov 10, 1965 · N9170B · Substantial damage NTSB LAX66D0170Accident · No injuriesClosedCessna 172 · Las Vegas, NVNov 7, 1965 · N5380R · Substantial damage NTSB CHI66A0046Accident · 3 fatalClosedCessna 172 · West Salem, OHNov 7, 1965 · N7346A · Destroyed NTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNOct 29, 1965 · N6345E · Substantial damage NTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damage

Back to Cessna 172