Skip to content

NTSB investigations · 20

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 ('7103902') 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 ('7103902')
  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 ('7103902')
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 ERA24LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-39 · Highgate, VTThe pilot’s inadvertent retraction of the landing gear during landing rollout, which resulted in a landing gear collapse.Oct 29, 2023 · N289WW · Substantial damage NTSB ERA22LA414Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-39 · Caldwell, NJThe pilot’s acute cerebrovascular event, which caused symptoms that diminished his situational awareness and prompted him to abort the takeoff, resulting in a runway excursion.Sep 9, 2022 · N8925Y · Substantial damage NTSB CEN13WA301Accident · 1 fatalForeign investigationPiper PA-39 · Wolfsbehringen, GermanyMay 27, 2013 · N8977Y · Substantial damage NTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceAug 25, 2007 · N13PF · Destroyed NTSB ATL04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Kissimmee, FLThe pilot's failure to maintain directional control which resulted in a collision with terrain and obstacles following a loss of right engine power.Dec 13, 2003 · N230SW · Substantial damage NTSB CHI94DCA01Accident · 1 fatalFinal reportPiper PA-39 · Viburnum, MOThe pilot's failure to maintain adequate airspeed during the turn to final. The gusty tailwind during the turn was a contributing factor.Feb 18, 1994 · N8913Y · Destroyed NTSB LAX93LA291Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Thermal, CAthe pilot's inadvertent movement of the landing gear selector switch to the up position. A factor in the accident was the difference in cockpit switch layout between the PA23 and PA39 aircraft.Jul 17, 1993 · N8975Y · Substantial damage NTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…Jul 31, 1988 · N2875A · Destroyed NTSB MKC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Peculiar, MODuring the landing roll at the plt's pvt air strip with a runway consisting of wet sod, the brakes were applied to stop the acft. The braking was ineffective and the acft departed the side of the runway. After departing the runway the main gear and nose gear…Apr 29, 1985 · N8943Y · Substantial damage NTSB MIA83LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-39 · N. Ft. Lauderda, FLPilot says he refueled at nassau with 20 gals in aux. Tanks. Estimated 10 gals each main tank. 45 minutes after departure #1 eng. Failed. 5 minutes later #2 failed. Aircraft sank.Oct 22, 1982 · N8856Y · Destroyed NTSB FTW82FRG13Accident · No injuriesClosedPiper PA-39 · Corpus Christi, TXNov 25, 1981 · N8882Y · Substantial damage NTSB CHI79FA072Accident · 2 fatalClosedPiper PA-39 · Bloomfield Twp, WISep 2, 1979 · N8859Y · 2 aircraft · Destroyed NTSB FTW76DPA23Accident · No injuriesClosedPiper PA-39 · Fairfield, TXApr 24, 1976 · N8895Y · Substantial damage NTSB MKC76FTK23Accident · Serious injuriesClosedPiper PA-39 · Mitchell, SDApr 23, 1976 · N8884Y · Destroyed NTSB IAD76AI053Accident · 3 fatalClosedPiper PA-39 · Clover Lick, WVJan 21, 1976 · N8868Y · Destroyed NTSB IAD74FID35Accident · No injuriesClosedPiper PA-39 · Tangier Isl, VAApr 27, 1974 · N8844Y · Substantial damage NTSB MIA74DLA21Accident · No injuriesClosedPiper PA-39 · Lake Como, FLNov 10, 1973 · N8868Y · Substantial damage NTSB NYC72FHD15Accident · No injuriesClosedPiper PA-39 · Ambler, PASep 22, 1971 · N8898Y · Substantial damage NTSB NYC72FGT03Accident · Minor injuriesClosedPiper PA-39 · W Milton, PAAug 31, 1971 · N8843Y · Destroyed NTSB MKC70FCD24Accident · No injuriesClosedPiper PA-39 · Cedar Rapids, IAMar 26, 1970 · N8871Y · Substantial damage

Back to Piper PA-39