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 ATL80FA063Accident · 2 fatalClosedPiper J-3 · Williamson, GAJun 28, 1980 · N42914 · Destroyed NTSB MIA80FA070Accident · 1 fatalClosedPiper J3C · Dunedin, FLJun 22, 1980 · N665WC · Destroyed NTSB ATL80FID19Accident · No injuriesClosedPiper J-3 · Quinton, VAMay 2, 1980 · N42779 · Substantial damage NTSB FTW80FPM08Accident · No injuriesClosedPiper J-3 · Bristow, OKMar 22, 1980 · N98236 · Substantial damage NTSB ANC80DAA07Accident · No injuriesClosedPiper J-3 · Ruby, AKFeb 14, 1980 · N78507 · Substantial damage NTSB LAX80DVG14Accident · Minor injuriesClosedPiper J3C-65 · Roseville, CAFeb 13, 1980 · N71048 · Substantial damage NTSB MKC80FCJ06Accident · Serious injuriesClosedPiper J3C · Milburn, NEJan 30, 1980 · N2764C · Substantial damage NTSB LAX80FVM09Accident · No injuriesClosedPiper J-3C · New Cuyana, CADec 15, 1979 · N71066 · Substantial damage NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB ANC80FA003Accident · 2 fatalClosedPiper J-3 · Georgetown, AKOct 10, 1979 · N6254H · Destroyed NTSB MKC79FCD45Accident · Minor injuriesClosedPiper J-3 · Madrid, IASep 25, 1979 · N98602 · Substantial damage NTSB IAD79FID35Accident · Minor injuriesClosedPiper PA-12 · Chesapeake, VASep 8, 1979 · N72HW · Substantial damage NTSB LAX79DVD37Accident · Minor injuriesClosedPiper J-3 · Point Reys, CASep 1, 1979 · N70660 · Destroyed NTSB LAX79DVG76Accident · Minor injuriesClosedPiper J3 · Pleasant Grove, CAAug 31, 1979 · N40615 · Substantial damage NTSB FTW79DPG79Accident · No injuriesClosedPiper J-3 · Fresno, ARAug 28, 1979 · N20886 · Substantial damage NTSB ANC79DAG97Accident · Minor injuriesClosedPiper J-3 · Shrode Lake, AKAug 28, 1979 · N87822 · Substantial damage NTSB CHI79FEM33Accident · 2 fatalClosedPiper J3C-65 · Grand Haven, MIAug 5, 1979 · N7421H · 2 aircraft · Destroyed NTSB MIA79FA108Accident · 2 fatalClosedPiper J-3C65 · Ft.Pierce, FLJul 22, 1979 · N26147 · Destroyed NTSB NYC79FFJ23Accident · Serious injuriesClosedPiper J-3 · Skaneateles, NYJul 14, 1979 · N42844 · Substantial damage NTSB SEA79FYM47Accident · Minor injuriesClosedPiper J-3 · Clatskanie, ORJul 8, 1979 · N38790 · Substantial damage NTSB IAD79DIA13Accident · Minor injuriesClosedPiper J-3 · Naylor, MDJun 16, 1979 · N1500N · Substantial damage NTSB FTW79FPG44Accident · Serious injuriesClosedPiper J3C-65 · Crawfordsville, ARJun 4, 1979 · N7900A · Substantial damage NTSB MKC79DCG50Accident · Minor injuriesClosedPiper J3C-65 · Richmond, KSJun 2, 1979 · N24905 · Substantial damage NTSB MKC79FER44Accident · 1 fatalClosedPiper PA-25 · Gaylord, MNMay 19, 1979 · N70152 · Destroyed NTSB OAK79DVD26Accident · Minor injuriesClosedPiper L-4B · Smith River, CAMay 13, 1979 · N8358H · Substantial damage NTSB MIA79FLD60Accident · Minor injuriesClosedPiper J-3C · Arcadia, FLApr 29, 1979 · N2156M · Substantial damage NTSB FTW79DRJ11Accident · Minor injuriesClosedPiper J-3 · Monterey, LAMar 25, 1979 · N6493H · Substantial damage NTSB SEA79FYM22Accident · Minor injuriesClosedPiper J3C-65 · Camas, WAMar 24, 1979 · N1326N · Substantial damage NTSB SEA79DYM12Accident · No injuriesClosedPiper J3C-65 · The Dalles, ORJan 28, 1979 · N5721N · Substantial damage NTSB NYC79FNA03Accident · No injuriesClosedPiper J3 · Merrimac, MAOct 8, 1978 · N5719N · Substantial damage NTSB FTW78FA079Accident · 2 fatalClosedPiper J3C · Ferris, TXSep 12, 1978 · N78430 · Destroyed NTSB NYC78FHM28Accident · No injuriesClosedPiper J-3 · West Milford, NJSep 10, 1978 · N92128 · 2 aircraft · Substantial damage NTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WASep 4, 1978 · N6391H · Destroyed NTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDSep 3, 1978 · N88185 · Destroyed NTSB MIA78FA116Accident · 2 fatalClosedPiper J3C · Homestead, FLAug 19, 1978 · N46917 · Destroyed NTSB MIA78FLD70Accident · Serious injuriesClosedPiper J3 · Ormond Beach, FLAug 10, 1978 · N30400 · 2 aircraft · Substantial damage NTSB IAD78FA092Accident · 1 fatalClosedPiper J-3 · White Marsh, MDAug 10, 1978 · N51537 · Destroyed NTSB FTW78FRD49Accident · Serious injuriesClosedPiper J-3 · Welsh, LAAug 7, 1978 · N3683K · Destroyed NTSB MIA78DKJ65Accident · No injuriesClosedPiper J-3 · Milton, FLJul 25, 1978 · N27979 · Substantial damage NTSB IAD78FIG14Accident · Serious injuriesClosedPiper J3C · Westport, MDJul 23, 1978 · N42442 · Substantial damage NTSB LAX78DUJ84Accident · No injuriesClosedPiper J-3C · Ganado, AZJul 16, 1978 · N98141 · Substantial damage NTSB LAX78DUJ83Accident · No injuriesClosedPiper J-3 · Wenden, AZJul 10, 1978 · N77590 · Destroyed NTSB NYC78DFA26Accident · Minor injuriesClosedPiper J-3 · West Carthage, NYJul 2, 1978 · N92629 · Destroyed NTSB MIA78DLG26Accident · No injuriesClosedPiper J-3 · Newberry, SCJul 2, 1978 · N2152M · Substantial damage NTSB FTW78DRA31Accident · Minor injuriesClosedPiper J3C-65 · Matagorda Pen, TXJul 2, 1978 · N98155 · Destroyed NTSB DEN78FTM26Accident · No injuriesClosedPiper J-3 · Provo, UTJun 25, 1978 · N92002 · Substantial damage NTSB MIA78FLG25Accident · Serious injuriesClosedPiper J3C · Harleyville, SCJun 21, 1978 · N70998 · Substantial damage NTSB SEA78FYP32Accident · Minor injuriesClosedPiper J3C-65 · Moses Lake, WAJun 10, 1978 · N98735 · Substantial damage NTSB MIA78DLD36Accident · No injuriesClosedPiper J3C-65 · Moss Bluff, FLApr 22, 1978 · N58378 · Substantial damage NTSB FTW78FPM08Accident · No injuriesClosedPiper J3C-65 · Catoosa, OKApr 7, 1978 · N6538H · Substantial damage

Back to Piper J3C-65