Skip to content

NTSB investigations: Piper PA-28R-200, MO

21 cases on aircraft the registry lists as Piper PA-28R-200. 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

19702026

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 ('7102811')) 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 ('7102811'))
  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 ('7102811'))
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 GAA16CA236Accident · No injuriesData collectionFinal reportPiper PA 28R · Lee's Summit, MOThe pilot's improper pitch control after the landing flare, resulting in an aerodynamic stall, hard landing, and consequent substantial left wing damage.May 12, 2016 · N228NC · Substantial damage NTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…Dec 21, 2003 · N56598 · Substantial damage NTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…May 31, 1998 · N9324N · Substantial damage NTSB CHI94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Joseph, MOthe loss of engine power due to the failure of the number two cylinder.Jun 17, 1994 · N5025S · Substantial damage NTSB CHI91FA091Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Dutchtown, MOThe pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.Feb 6, 1991 · N3966X · Destroyed NTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.Jun 21, 1988 · N4490T · Substantial damage NTSB MKC85LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Kansas City, MOPlt inadvertently entered clouds on VFR flight. Plt sighted an arpt through breaks in clouds and decided to land. The acft touched down short of a closed rwy, partially collapsing the left gear. It then bounced up onto the rwy and fully collapsed the left…Apr 29, 1985 · N300KR · Substantial damage NTSB MKC82FCG06Accident · Minor injuriesClosedPiper PA-28R · Macomb, MONov 5, 1981 · N5084S · Substantial damage NTSB MKC79FCG77Accident · Serious injuriesClosedPiper PA-28R · Lake Winnebago, MOSep 11, 1979 · N1094X · Destroyed NTSB MKC78DCA52Accident · No injuriesClosedPiper PA-28R · Memphis, MOSep 27, 1978 · N9350K · Substantial damage NTSB MKC78FCG37Accident · No injuriesClosedPiper PA-28R · Springfield, MOJun 19, 1978 · N55306 · Substantial damage NTSB MKC77FCA08Accident · No injuriesClosedPiper PA-28R · Chesterfield, MOJan 8, 1977 · N3982X · Substantial damage NTSB MKC77FCA04Accident · No injuriesClosedPiper PA-28R · Chesterfield, MONov 20, 1976 · N9354N · Substantial damage NTSB MKC76AK069Accident · 5 fatalClosedPiper PA-28R · Huntsville, MOJul 24, 1976 · N7941C · 2 aircraft · Destroyed NTSB MKC76DCA17Accident · No injuriesClosedPiper PA-28R · Chesterfield, MOMar 1, 1976 · N2733R · Substantial damage NTSB MKC75DCA21Accident · Minor injuriesClosedPiper PA-28R · Kennett, MOMar 13, 1975 · N3094R · Substantial damage NTSB MKC74DCG31Accident · No injuriesClosedPiper PA-28R · Crane, MOApr 14, 1974 · N16566 · Substantial damage NTSB MKC74FCG25Accident · No injuriesClosedPiper PA-28R · Columbia, MOMar 23, 1974 · N2759R · Substantial damage NTSB MKC74AK025Accident · 2 fatalClosedPiper PA-28R · Columbia, MONov 19, 1973 · N2307T · Destroyed NTSB MKC71FCG49Incident · No injuriesClosedPiper PA-28R · Springfield, MOMar 21, 1971 · N2109T · Minor damage NTSB MKC71DCG21Accident · No injuriesClosedPiper PA-28R · Latham, MOAug 21, 1970 · N4985S · Substantial damage