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 MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDDec 22, 1974 · N98755 · Substantial damage NTSB FTW75FRD19Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LADec 21, 1974 · N70273 · 2 aircraft · Minor damage NTSB CHI75FEC24Accident · Serious injuriesClosedPiper J3C-65 · Ypsilanti, MINov 22, 1974 · N2472C · Substantial damage NTSB MIA75FLD33Accident · No injuriesClosedPiper J3C-65 · Plant City, FLNov 9, 1974 · N66061 · Substantial damage NTSB CHI75AC040Accident · No injuriesClosedPiper J3C-65 · Pickett, WINov 9, 1974 · N26046 · No damage NTSB NYC75FHD17Accident · Minor injuriesClosedPiper J-3 · Bridgeport, NJAug 27, 1974 · N42843 · Substantial damage NTSB CHI75FEC10Accident · No injuriesClosedPiper J3C · Fair Haven, MIAug 20, 1974 · N35670 · Substantial damage NTSB CHI75FEE12Accident · 1 fatalClosedPiper J3C-65 · Kankakee, ILAug 18, 1974 · N35258 · Destroyed NTSB MIA74DKJ04Accident · Serious injuriesClosedPiper J3C · Guntersville, ALJul 21, 1974 · N7473H · Substantial damage NTSB MIA74FLE07Accident · No injuriesClosedPiper J3C-65 · Ormond Beach, FLJun 13, 1974 · N30400 · Substantial damage NTSB MIA74DLD90Accident · No injuriesClosedPiper J-3 · Lake Placid, FLJun 5, 1974 · N98576 · Substantial damage NTSB FTW74DPJ33Accident · No injuriesClosedPiper J-3 · Alva, OKMay 26, 1974 · N33201 · Substantial damage NTSB FTW74AF083Accident · 2 fatalClosedPiper J3C-65 · Normangee, TXMay 12, 1974 · N6010H · Substantial damage NTSB DEN74DTE75Accident · No injuriesClosedPiper J-3 · Delta, COMay 10, 1974 · N70859 · Substantial damage NTSB SEA74FYC44Accident · 1 fatalClosedPiper J3C-65 · Cornelius, ORApr 16, 1974 · N92304 · Substantial damage NTSB OAK74FVG30Accident · No injuriesClosedPiper J-3 · Vacaville, CAFeb 11, 1974 · N20210 · Substantial damage NTSB NYC74FNE15Accident · No injuriesClosedPiper J3C-65 · Windsor, MAFeb 6, 1974 · N87926 · Substantial damage NTSB NYC74FGM16Accident · Serious injuriesClosedPiper J3C-65 · Waynesburg, PAFeb 3, 1974 · N88361 · Substantial damage NTSB ANC74DAG86Accident · No injuriesClosedPiper J3C-65 · Anchorage, AKFeb 3, 1974 · N88235 · Substantial damage NTSB CHI74FEK14Accident · No injuriesClosedPiper J3C-65 · London, OHJan 30, 1974 · N92224 · Substantial damage NTSB FTW74FRG50Accident · Serious injuriesClosedPiper J-3 · Cibolo, TXJan 16, 1974 · N7442H · Destroyed NTSB MKC74DCJ24Accident · No injuriesClosedPiper J3C-65 · Spalding, NEJan 13, 1974 · N3523K · Substantial damage NTSB CHI74FEK13Accident · No injuriesClosedPiper J3C-65 · Worthington, OHJan 12, 1974 · N6718H · Substantial damage NTSB SEA74DTA14Accident · No injuriesClosedPiper J-3 · Culbertson, MTNov 21, 1973 · N70234 · Substantial damage NTSB FTW74FPG32Accident · Serious injuriesClosedPiper J3C-65 · Lepanto, AROct 18, 1973 · N33034 · Destroyed NTSB DEN74DQA20Accident · Minor injuriesClosedPiper J-3 · Stead, NMOct 14, 1973 · N88240 · Substantial damage NTSB FTW74FPJ11Accident · 1 fatalClosedPiper J-3 · Elk City, OKOct 12, 1973 · N59625 · Destroyed NTSB MKC74DER17Accident · No injuriesClosedPiper J-3 · Blackduck, MNSep 30, 1973 · N88553 · Substantial damage NTSB FTW74FRG21Accident · No injuriesClosedPiper J3C-65 · Burnet, TXSep 30, 1973 · N42736 · Substantial damage NTSB IAD74FIG10Accident · No injuriesClosedPiper J-3 · College Park, MDSep 23, 1973 · N38004 · Substantial damage NTSB CHI74AC021Accident · 1 fatalClosedPiper J-3 · Marysville, OHSep 6, 1973 · N2051M · Substantial damage NTSB NYC74FGM04Accident · No injuriesClosedPiper J3C-65 · Pittsfield, PASep 3, 1973 · N92636 · Substantial damage NTSB NYC74DNA13Accident · No injuriesClosedPiper J-3 · Greene, RISep 1, 1973 · N6987H · Substantial damage NTSB FTW74DPG17Accident · No injuriesClosedPiper J-3 · Stuttgart, ARAug 27, 1973 · N71022 · Substantial damage NTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCAug 25, 1973 · N7001H · Substantial damage NTSB CHI74DEP12Accident · Minor injuriesClosedPiper J-3 · Neena, WIAug 12, 1973 · N98200 · Substantial damage NTSB ANC74DAG18Accident · No injuriesClosedPiper J-3 · Grizzly Lake, AKAug 12, 1973 · N98401 · Substantial damage NTSB FTW74DPG09Accident · No injuriesClosedPiper J-3 · Arkadelphia, ARJul 25, 1973 · N30799 · Substantial damage NTSB ANC74GAG10Accident · No injuriesClosedPiper J3 · Wasilla, AKJul 22, 1973 · N70656 · Substantial damage NTSB MIA74DLA02Accident · No injuriesClosedPiper J-3 · Pensacola, FLJul 21, 1973 · N1971M · Substantial damage NTSB NYC74AN001Accident · 1 fatalClosedPiper J3C-65 · Panther Lake, NYJul 4, 1973 · N98355 · Destroyed NTSB MKC73DCJ44Accident · No injuriesClosedPiper J3C-65 · Lodgepole, NEJun 2, 1973 · N6786H · Substantial damage NTSB NYC73FNC73Accident · No injuriesClosedPiper J3-65 · Augusta, MEMay 26, 1973 · N42571 · Substantial damage NTSB IAD733ID20Accident · No injuriesClosedPiper J3C-65 · Blairs, VAApr 29, 1973 · N70449 · Substantial damage NTSB LAX73DUG45Accident · No injuriesClosedPiper J3C-65 · Apple Vally, CAApr 3, 1973 · N42130 · Substantial damage NTSB IAD73A1006Accident · 2 fatalClosedPiper J3 · Brundidge, ALMar 24, 1973 · N98633 · Destroyed NTSB NYC73FNC55Accident · No injuriesClosedPiper J3C-65 · Springfield, VTFeb 23, 1973 · N1401V · Substantial damage NTSB FTW73DPJ08Accident · No injuriesClosedPiper J3C · Alva, OKJan 30, 1973 · N98850 · Substantial damage NTSB CHI73FEA22Accident · Minor injuriesClosedPiper J3C-65 · Terre Haute, INJan 25, 1973 · N92343 · Destroyed NTSB LAX73FUM14Accident · No injuriesClosedPiper J3C-65 · Carlsbad, CAJan 18, 1973 · N98140 · Substantial damage

Back to Piper J3C-65