Skip to content

NTSB investigations: Piper PA-30, MO

24 cases on aircraft the registry lists as Piper PA-30. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

Latest cases

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002')) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002'))
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002'))
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 CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…Oct 10, 2024 · N7577Y · Substantial damage NTSB CEN12LA512Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bragg City, MOThe pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation.Jul 29, 2012 · N8121Y · Substantial damage NTSB CHI05FA189Accident · 3 fatalField investigationFinal reportPiper PA-30 · Aurora, MOThe pilot not maintaining adequate airspeed and aircraft control during initial climb, which resulted in an inadvertent stall/spin at a low altitude. A factor to the accident was the pilot operating the airplane over its certified maximum gross weight.Jul 18, 2005 · N7868Y · Substantial damage NTSB CHI02FA215Accident · 1 fatalField investigationFinal reportPiper PA-30 · Marble Hill, MOThe solid fuel system contamination resulting in a loss of engine power. The inadequate emergency procedures, and the airspeed not maintained by the pilot were additional causes.Jul 25, 2002 · N8563Y · Destroyed NTSB CHI93LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Branson, MOthe fractured nose gear retract arm which allowed the nose gear to collapse.Jul 16, 1993 · N7636Y · Substantial damage NTSB CHI90GA273Incident · No injuriesFinal reportPiper PA-3O · Cape Girardeau, MOExcessive play in the landing gear extension linkage. A factor in the incident was unreliability of the gear indicating system.Sep 23, 1990 · N752CF · Minor damage NTSB MKC89LA122Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbia, MOThe gear-up landing which was made by an unknown/unauthorized person.Jun 1, 1989 · N154P · Substantial damage NTSB MKC83LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Springfield, MOThe student pilot retracted the landing gear during landing roll. This was to be a touch and go landing and the student had just raised the flaps in preparation for takeoff. The instructor stated that during the landing roll the student pilot moved the gear…Apr 27, 1983 · N8301Y · Substantial damage NTSB MKC81FCG08Accident · No injuriesClosedPiper PA-30 · Springfield, MOOct 21, 1980 · N8456Y · Substantial damage NTSB MKC79DCG03Accident · No injuriesClosedPiper PA-30 · Nevada, MOOct 10, 1978 · N7900Y · Substantial damage NTSB MKC78DCA01Accident · No injuriesClosedPiper PA-30 · Festus, MOOct 16, 1977 · N7885Y · Substantial damage NTSB MKC77FCA31Accident · No injuriesClosedPiper PA-30 · Vichy, MOSep 22, 1977 · N7866Y · Substantial damage NTSB MKC77FA006Accident · No injuriesClosedPiper PA-30B · St Louis, MONov 30, 1976 · N8489Y · Substantial damage NTSB MKC76FCG34Accident · No injuriesClosedPiper PA-30 · Bolivar, MONov 10, 1975 · N7465Y · Substantial damage NTSB MKC76FCG11Accident · No injuriesClosedPiper PA-30 · Kansas City, MOJul 24, 1975 · N7103Y · Substantial damage NTSB MKC75FCG30Accident · No injuriesClosedPiper PA-30 · Kansas City, MOFeb 10, 1975 · N300RE · Substantial damage NTSB MKC75FCG26Accident · No injuriesClosedPiper PA-30 · Bolivar, MODec 19, 1974 · N7465Y · Substantial damage NTSB MKC74AK007Accident · No injuriesClosedPiper PA-30 · Kansas City, MOAug 17, 1973 · N7876Y · Substantial damage NTSB MKC74FCA02Accident · Minor injuriesClosedPiper PA-30 · Summersville, MOJul 20, 1973 · N8400Y · Substantial damage NTSB CHI72AC054Accident · 2 fatalClosedPiper PA-30 · Chesterfield, MODec 26, 1971 · N7756Y · Destroyed NTSB MKC72FCA18Accident · Serious injuriesClosedPiper PA-30 · Scott City, MODec 7, 1971 · N8040Y · Destroyed NTSB MKC71AK029Accident · 1 fatalClosedPiper PA-30 · Fulton, MONov 29, 1970 · N431AP · Destroyed NTSB MKC71DCG28Accident · No injuriesClosedPiper PA-30 · Cassville, MOOct 23, 1970 · N8161Y · Substantial damage NTSB MKC68A0023Accident · 2 fatalClosedPiper PA-30 · Winona, MOSep 20, 1967 · N8360Y · Destroyed