Skip to content

NTSB investigations: Piper PA-28-151, MO

16 cases on aircraft the registry lists as Piper PA-28-151. 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

19752026

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 ('7102805', '7104223')) 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 ('7102805', '7104223'))
  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 ('7102805', '7104223'))
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 GAA18CA402Accident · No injuriesData collectionFinal reportPiper PA28 · Rolla, MOA collision with a deer on the runway during the takeoff roll at night.Jun 28, 2018 · N7104F · Substantial damage NTSB CHI08LA006Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Festus, MOThe pilot's inadequate aircraft preflight, fuel system water contamination and fuel starvation which resulted in a loss of engine power during landing approach. An additional cause was the emergency landing procedure not followed by the pilot following a loss…Oct 8, 2007 · N43246 · Substantial damage NTSB CHI00LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fulton, MOthe pilot's poor inflight planning which resulted in exceeded the proper touchdown point on the runway. A factor associated with the accident was the ditch that the airplane contacted.May 6, 2000 · N8641E · Substantial damage NTSB CHI96LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · New Melle, MOthe pilot's selection of an unsuitable area for an emergency/precautionary landing. Factors relating to the accident were: the pilot's continual operation of the airplane with a known deficiency (broken trim switch); an uncommanded activation of the elevator…Jul 28, 1996 · N44059 · Substantial damage NTSB MKC90LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Columbia, MOAircraft control not maintained resulting in a stall/mush by the PIC.Jul 15, 1990 · N555TT · Destroyed NTSB MKC90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · St. Louis, MOInadequate maintenance and proper touchdown point not attained by the pilot in command.May 2, 1990 · N3986X · Substantial damage NTSB MKC85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Springfield, MOThe acft collided with trees during a forced landing, while on a dual instructional flt. The CFI said after the climb tocruise the eng began to slow dwn. The CFI took control of the acft to return to arpt of departure. He said the vibrationwas excessive as…Nov 3, 1984 · N44095 · Substantial damage NTSB MKC83FA205Accident · 2 fatalField investigationFinal reportPiper PA-24-151 · Chesterfield, MOThe plt landed a lawrenceburg, TN, on the evening of 8/28/83. Thunderstorms were reported in the area at that time. At lawrenceburg, fuel was available during daylight hours. At 0203 the next morning, the plt called the muscle shoals fss & obtained a wx…Aug 29, 1983 · N7993C · Substantial damage NTSB MKC81DCA11Accident · No injuriesClosedPiper PA-28 · St Charles, MOApr 29, 1981 · N41606 · Substantial damage NTSB MKC80DCG32Accident · No injuriesClosedPiper PA-28 · Excelsior Spgs, MOJul 1, 1980 · N33480 · Substantial damage NTSB MKC78FCA50Accident · No injuriesClosedPiper PA-28 · Thayer, MOSep 4, 1978 · N32411 · Substantial damage NTSB MKC78FCA15Accident · No injuriesClosedPiper PA-28 · Chesterfield, MOFeb 10, 1978 · N75274 · Substantial damage NTSB MKC78DCA12Accident · No injuriesClosedPiper PA-22 · Chesterfield, MODec 29, 1977 · N5467Z · 2 aircraft · Substantial damage NTSB MKC77DCG04Accident · Minor injuriesClosedPiper PA-28 · Warrensburg, MOOct 14, 1977 · N7006C · Substantial damage NTSB MKC76FCG63Accident · No injuriesClosedPiper PA-28 · Monett, MOMar 28, 1976 · N40857 · Substantial damage NTSB MKC75AK039Accident · 3 fatalClosedPiper PA-28 · St Thomas, MOFeb 10, 1975 · N41717 · Destroyed