Skip to content

NTSB investigations · 1,195

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 ('7100510') 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 ('7100510')
  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 ('7100510')
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 NYC78DNC19Accident · Minor injuriesClosedPiper J-3 · Croydon, NHMar 10, 1978 · N35054 · Substantial damage NTSB NYC78FNA14Accident · No injuriesClosedPiper J3 · Haverhill, MAJan 29, 1978 · N5719N · Substantial damage NTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANov 27, 1977 · N88338 · Destroyed NTSB FTW78DRJ06Accident · No injuriesClosedPiper J3C · Pineville, LANov 2, 1977 · N71022 · Substantial damage NTSB MIA78DLD06Accident · No injuriesClosedPiper J3 · Ft Pierce, FLOct 23, 1977 · N70701 · Substantial damage NTSB FTW78DRD06Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LAOct 23, 1977 · N70273 · Substantial damage NTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNOct 22, 1977 · N98067 · Destroyed NTSB LAX77FUQ45Accident · No injuriesClosedPiper J3C-65 · Pacoima, CAAug 24, 1977 · N6513H · Substantial damage NTSB FTW77FRD42Accident · Serious injuriesClosedPiper J3-C65 · Beaux Bridge, LAJul 31, 1977 · N71024 · Destroyed NTSB IAD77DID23Accident · Minor injuriesClosedPiper J3C-65 · Woolwine, VAJul 3, 1977 · N7157H · Substantial damage NTSB FTW77FPJ28Accident · Minor injuriesClosedPiper J3C-65 · Yukon, OKJul 3, 1977 · N87791 · Substantial damage NTSB ANC77DAG89Accident · No injuriesClosedPiper J-3 · Homer, AKJul 3, 1977 · N71081 · Substantial damage NTSB FTW77FRA27Accident · 2 fatalClosedPiper J3C-65 · Waller, TXJun 19, 1977 · N38101 · 2 aircraft · Destroyed NTSB MIA77DLD66Accident · No injuriesClosedPiper J3 · Bartow, FLJun 14, 1977 · N98606 · Substantial damage NTSB ANC77DAG66Accident · No injuriesClosedPiper J-3 · Kenai, AKJun 11, 1977 · N6505H · Substantial damage NTSB SEA77FTA21Accident · No injuriesClosedPiper J3C-65 · Scobey, MTJun 6, 1977 · N35214 · Substantial damage NTSB MKC77DTG08Accident · No injuriesClosedPiper J-3 · Kenmare, NDJun 5, 1977 · N32668 · Substantial damage NTSB CHI77FEV26Accident · Serious injuriesClosedPiper J-3 · Manito, ILJun 4, 1977 · N70907 · Substantial damage NTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKMay 24, 1977 · N6355H · Destroyed NTSB FTW77FPD24Accident · Minor injuriesClosedPiper J3C-65 · Roanoke, TXMay 21, 1977 · N5341N · Substantial damage NTSB NYC77FNE18Accident · Minor injuriesClosedPiper J3 · Fairfield, CTMay 16, 1977 · N6661H · Substantial damage NTSB SEA77DYM31Accident · No injuriesClosedPiper J-3 · Yacolt, WAMay 14, 1977 · N42448 · Destroyed NTSB SEA77FTA16Accident · No injuriesClosedPiper J3 · Otter, MTApr 23, 1977 · N70209 · Substantial damage NTSB MIA77FKT63Accident · Serious injuriesClosedPiper J-3 · Moore Haven, FLApr 16, 1977 · N42684 · Substantial damage NTSB MIA77FKJ30Accident · Minor injuriesClosedPiper J3 · Graysville, ALApr 16, 1977 · N30451 · Substantial damage NTSB MIA77DKJ31Accident · Serious injuriesClosedPiper J-3 · Mobile, ALApr 16, 1977 · N65881 · Substantial damage NTSB MIA77DLD37Accident · Minor injuriesClosedPiper J-3 · Okeechobee, FLMar 20, 1977 · N92025 · Destroyed NTSB NYC77FHM11Accident · Minor injuriesClosedPiper J-3 · Warwick, NYMar 6, 1977 · N92404 · Substantial damage NTSB CHI77FEM14Accident · Minor injuriesClosedPiper J-3 · Steuben, MIJan 30, 1977 · N98761 · Substantial damage NTSB NYC77FA028Accident · 1 fatalClosedPiper J3C65 · Duanesburg, NYJan 15, 1977 · N87955 · Substantial damage NTSB MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GADec 19, 1976 · N42595 · Destroyed NTSB NYC77FFA11Accident · Minor injuriesClosedPiper J-3 · Marlboro, NYDec 18, 1976 · N24565 · Substantial damage NTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNov 28, 1976 · N2228M · Destroyed NTSB MKC77DCG04Accident · No injuriesClosedPiper J-3 · Carthage, MOOct 17, 1976 · N77508 · 2 aircraft · Substantial damage NTSB LAX77DUQ03Accident · No injuriesClosedPiper J-3 · Newhall, CAOct 10, 1976 · N38108 · Substantial damage NTSB MKC76DCD67Accident · No injuriesClosedPiper PA-22 · Marion, IASep 17, 1976 · N87760 · Substantial damage NTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MISep 11, 1976 · N87943 · Substantial damage NTSB MIA76FKH05Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, GASep 5, 1976 · N70546 · Substantial damage NTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LAAug 23, 1976 · N41263 · Substantial damage NTSB FTW76DPA34Accident · No injuriesClosedPiper J3C · Caddo Mills, TXAug 22, 1976 · N25033 · Substantial damage NTSB IAD76AI090Accident · 1 fatalClosedPiper J-3 · Ooltewah, TNAug 8, 1976 · N1360M · Substantial damage NTSB IAD76AI088Accident · 1 fatalClosedPiper J3C · Troy, NCJul 31, 1976 · N3353N · Destroyed NTSB MIA76FLG43Accident · No injuriesClosedPiper J-3 · Aiken, SCJul 21, 1976 · N35096 · Substantial damage NTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MOJul 17, 1976 · N42755 · Substantial damage NTSB SEA76DYG65Accident · No injuriesClosedPiper J3C · Moses Lake, WAJul 10, 1976 · N98735 · Substantial damage NTSB MKC76FTK31Accident · Serious injuriesClosedPiper J3C-65 · Onida, SDJul 10, 1976 · N3423N · Substantial damage NTSB FTW76DQG98Accident · No injuriesClosedPiper J3C · Farwell, TXJul 9, 1976 · N75066 · Substantial damage NTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GAJul 7, 1976 · N70419 · Destroyed NTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WIJul 3, 1976 · N30714 · Substantial damage NTSB NYC76FGM37Accident · No injuriesClosedPiper J-3 · Jeanette, PAJun 28, 1976 · N42574 · Substantial damage

Back to Piper J3C-65