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 CHI66D0379Accident · No injuriesClosedCessna 172 · Greenwood, INOct 17, 1965 · N6105E · Substantial damage NTSB NYC66F0311Accident · No injuriesClosedCessna 172 · Farmingdale, NJOct 12, 1965 · N7091T · Substantial damage NTSB SEA66A0025Accident · 1 fatalClosedCessna 172 · Puyallup, WAOct 10, 1965 · N5724A · Destroyed NTSB DEN66F0131Accident · No injuriesClosedCessna 172 · Albin, WYOct 7, 1965 · N8058B · Substantial damage NTSB CHI66F0355Accident · No injuriesClosedCessna 172 · Delaware, OHOct 7, 1965 · N6430E · Substantial damage NTSB LAX66F0112Accident · No injuriesClosedCessna 172 · Santa Monica, CAOct 3, 1965 · N8307B · Substantial damage NTSB LAX66D0148Accident · No injuriesClosedCessna 172 · Santa Susana, CAOct 2, 1965 · N5622A · Substantial damage NTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WISep 22, 1965 · N6287E · Substantial damage NTSB NYC66D0231Accident · No injuriesClosedCessna 172 · Litchfield, CTSep 9, 1965 · N8790B · Substantial damage NTSB MIA66F0245Accident · No injuriesClosedCessna 172 · Clearwater, FLSep 4, 1965 · N4105F · Substantial damage NTSB FTW66D0318Accident · No injuriesClosedCessna 172 · Vinita, OKAug 28, 1965 · N8809B · Substantial damage NTSB FTW66D0272Accident · No injuriesClosedCessna 172 · De Quincy, LAAug 26, 1965 · N5621A · Substantial damage NTSB CHI66F0204Accident · No injuriesClosedCessna 172 · Nokomis, ILAug 23, 1965 · N6421E · Substantial damage NTSB MIA66F0174Accident · No injuriesClosedCessna 172 · Little Mtn., SCAug 18, 1965 · N7476A · Substantial damage NTSB OAK66F0068Accident · Minor injuriesClosedCessna 172 · Beckwourth, CAAug 16, 1965 · N6388E · Substantial damage NTSB MKC66F0167Accident · No injuriesClosedCessna 172 · Wichita, KSAug 15, 1965 · N5945A · Substantial damage NTSB DEN66F0059Accident · No injuriesClosedCessna 172 · Salt Lake City, UTAug 3, 1965 · N7079T · Substantial damage NTSB OAK66D0072Accident · No injuriesClosedCessna 172 · Placerville, CAAug 2, 1965 · N8089B · Substantial damage NTSB NYC66D0157Accident · No injuriesClosedCessna 172 · Slocum, RIJul 30, 1965 · N7062A · Substantial damage NTSB NYC66D0140Accident · No injuriesClosedCessna 172 · Princess Anne, MDJul 26, 1965 · N6325E · Substantial damage NTSB NYC66D0134Accident · No injuriesClosedCessna 172 · Atlantic City, NJJul 25, 1965 · N6456E · Substantial damage NTSB FTW66A0007Accident · 1 fatalClosedCessna 172 · 2e Chelsea, OKJul 25, 1965 · N7031A · Destroyed NTSB NYC66F0053Accident · Minor injuriesClosedCessna 172 · Pavilion, NYJul 5, 1965 · N6263E · Substantial damage NTSB MIA66F0097Accident · Minor injuriesClosedCessna 172 · Vero Beach, FLJun 28, 1965 · N6232E · Substantial damage NTSB CHI66D0020Accident · No injuriesClosedCessna 172 · Cleveland, OHJun 26, 1965 · N16QB · Substantial damage NTSB MIA65A0124Accident · 3 fatalClosedCessna 172 · Toccoa, GAJun 19, 1965 · N4253F · Destroyed NTSB MIA66D0040Accident · No injuriesClosedCessna 172 · Wayside, MSJun 18, 1965 · N6417B · Substantial damage NTSB DEN66D0011Accident · No injuriesClosedCessna 172 · Albuquerque, NMJun 11, 1965 · N8333B · Substantial damage NTSB MIA65F0124Accident · Serious injuriesClosedCessna 172 · Rutherford, TNJun 5, 1965 · N6073A · Substantial damage NTSB DEN65F0097Accident · Minor injuriesClosedCessna 172 · Sundance, WYMay 30, 1965 · N4077F · Substantial damage NTSB DEN65F0111Accident · No injuriesClosedCessna 172 · Albuquerque, NMMay 29, 1965 · N6668A · Substantial damage NTSB MIA65F0122Accident · Minor injuriesClosedCessna 172 · Tampa, FLMay 26, 1965 · N7392A · Substantial damage NTSB NYC66D0018Accident · No injuriesClosedCessna 172 · Hillsboro, WVMay 24, 1965 · N8774B · Substantial damage NTSB CHI65F0169Accident · No injuriesClosedCessna 172 · Harrison, OHMay 19, 1965 · N6919A · Substantial damage NTSB CHI65D0167Accident · No injuriesClosedCessna 172 · Lafayette, INMay 19, 1965 · N7475A · Substantial damage NTSB MIA65F0105Accident · Minor injuriesClosedCessna 172 · Mcbee, SCMay 16, 1965 · N8288B · Substantial damage NTSB OAK65A0066Accident · 1 fatalClosedCessna 172 · Lake Tahoe, CAMay 8, 1965 · N8704U · Destroyed NTSB SEA66D0041Accident · No injuriesClosedCessna 172 · Knobs, MTMay 6, 1965 · N7082T · Substantial damage NTSB MIA65A0111Accident · 1 fatalClosedCessna 172 · St Cloud, FLMay 3, 1965 · N8880U · Destroyed NTSB FTW65F0038Accident · No injuriesClosedCessna 172 · Alvin, TXApr 25, 1965 · N7959B · Substantial damage NTSB MIA65A0105Accident · 2 fatalClosedCessna 172 · Evergreen, ALApr 24, 1965 · N8004B · Destroyed NTSB NYC65F0172Accident · No injuriesClosedCessna 172 · New London, VAApr 23, 1965 · N7114A · Substantial damage NTSB MKC65D0100Accident · No injuriesClosedCessna 172 · Ogallala, NEApr 21, 1965 · N5828A · Substantial damage NTSB SEA65F0051Accident · Serious injuriesClosedCessna 172 · Newberg, ORApr 20, 1965 · N7140T · Destroyed NTSB MKC66F0058Accident · Minor injuriesClosedCessna 172 · Murray, IAApr 11, 1965 · N5749A · Substantial damage NTSB MKC65F0117Accident · No injuriesClosedCessna 172 · St Charles, MOApr 11, 1965 · N8894B · Substantial damage NTSB UNK65X1483Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoApr 10, 1965 · N8779B · Substantial damage NTSB NYC65D0175Accident · No injuriesClosedCessna 172 · Blackwood, NJApr 10, 1965 · N6049A · Substantial damage NTSB OAK65F0053Accident · No injuriesClosedCessna 172 · San Jose, CAApr 4, 1965 · N7337A · Substantial damage NTSB CHI65F0108Accident · No injuriesClosedCessna 172 · South Haven, MIMar 31, 1965 · N8934B · Destroyed

Back to Cessna 172