Skip to content

NTSB investigations · 17

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 ('7100503') 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 ('7100503')
  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 ('7100503')
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 GAA18CA001Accident · No injuriesData collectionFinal reportPiper J3C · Yakima, WAThe flight instructor's failure to maintain directional control during the takeoff roll.Oct 3, 2017 · N48694 · Substantial damage NTSB ERA10CA366Accident · No injuriesData collectionFinal reportPiper J-3C · Buckhead, GAAn in-flight encounter with a downdraft during a go-around, resulting in a collision with trees and the ground.Jul 18, 2010 · N98342 · Substantial damage NTSB CHI96LA022Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Rochester, INfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall. A factor relating to the accident was: the gusty wind condition.Oct 29, 1995 · N88037 · Destroyed NTSB ATL83LA109Accident · No injuriesLimited investigationFinal reportPiper J-3C · Stockbridge, GAThe acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the…Feb 18, 1983 · N88037 · Substantial damage NTSB MIA77DLD12Accident · No injuriesClosedPiper J-3 · Venice, FLNov 1, 1976 · N87939 · Substantial damage NTSB ANC77DAH08Accident · Serious injuriesClosedPiper J3C · Sheep Mtn, AKOct 6, 1976 · N7335H · Substantial damage NTSB SEA76FYI24Accident · Minor injuriesClosedPiper J-3 · Salt Crk Falls, ORSep 19, 1976 · N8360H · Substantial damage NTSB MKC76FCJ19Accident · Serious injuriesClosedPiper J-3 · Neligh, NEDec 9, 1975 · N42511 · Destroyed NTSB MIA76DLG18Accident · Minor injuriesClosedPiper J3 · Mauldin, SCSep 28, 1975 · N4504H · Substantial damage NTSB MIA73FKG51Accident · No injuriesClosedPiper J3C-65 · Cordele, GADec 3, 1972 · N3545N · Substantial damage NTSB MIA73DLG03Accident · Minor injuriesClosedPiper J-3 · Aiken, SCJul 2, 1972 · N5147B · Substantial damage NTSB OAK72DVW31Accident · No injuriesClosedPiper J3C-65 · Las Vegas, NVMay 15, 1972 · N48947 · Destroyed NTSB CHI68D0192Accident · No injuriesClosedPiper J-3 · Hager City, WIAug 13, 1967 · N92477 · Destroyed NTSB MKC66F0115Accident · No injuriesClosedPiper J3C · Viewfield, SDMay 29, 1965 · N70927 · Substantial damage NTSB MIA65F0106Accident · Serious injuriesClosedPiper J3C · Louisburg, NCMay 21, 1965 · N30226 · Substantial damage NTSB NYC65F0199Accident · No injuriesClosedPiper J3C · North Norwich, NYApr 25, 1965 · N88158 · Substantial damage NTSB MKC65F0012Accident · No injuriesClosedPiper J3 · Kenesaw, KSJan 30, 1965 · N88037 · Substantial damage

Back to Piper J-3C