Skip to content

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

23 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

19722026

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…Mar 26, 2005 · N999SK · Destroyed NTSB CHI01LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jeffersonville, INThe airplane was struck by deer during landing roll at night. A factor was the dark night.Jul 28, 2001 · N2125T · Substantial damage NTSB CHI00LA293Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Sellersburg, INthe improper servicing of the emergency extension assembly and the gear extension not verified by company maintenance personnel. Factors were the failure of the hydraulic system's motor, normal and emergency gear extension not available to the pilot, and the…Sep 1, 2000 · N1334T · Substantial damage NTSB CHI98LA298Accident · No injuriesLimited investigationFinal reportPiper PA28-R-200 · W. Frankfort, INThe failure of the fuel mixture control linkage, and inadequate inspections by maintenance personnel.Aug 3, 1998 · N4596T · Substantial damage NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.Jul 27, 1997 · N5027T · Substantial damage NTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.Jul 31, 1994 · N32736 · Destroyed NTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.Jan 2, 1989 · N2CL · Destroyed NTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.Aug 27, 1988 · N5140S · Destroyed NTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INMay 20, 1988 · N55786 · Substantial damage NTSB CHI87LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · South Bend, INDuring cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical…Nov 10, 1986 · N578PA · Substantial damage NTSB CHI84LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lafayette, INThe pilot was practicing accuracy landings when he noticed that the acft had blown away from the rwy. When he attempted to increase the throttle setting there was no response. In an attempt to land on a highway on-ramp the acft struck an electric wire, a…Apr 8, 1984 · N56738 · Destroyed NTSB CHI84LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INThe acft made an off arpt forced landing after the engine quit. According to the plt, the flt departed wichita falls, TX at 1516 with 48 gallons of fuel on board. When about 7 miles south-southeast of Terre Haute, IN, the engine quit. Theplt tried to restart…Dec 27, 1983 · N44042 · Substantial damage NTSB CHI82FA008Accident · 2 fatalClosedPiper PA-28 · Mooresville, INOct 25, 1981 · N70RA · Destroyed NTSB CHI81FA016Accident · 2 fatalClosedPiper PA-28R · Elkhart, INDec 31, 1980 · N8708E · Destroyed NTSB CHI79FA023Accident · 2 fatalClosedPiper PA-28R · Memphis, INJan 19, 1979 · N1885F · Destroyed NTSB CHI78FEX11Accident · No injuriesClosedPiper PA-28R · Monticello, INApr 1, 1978 · N8065C · Substantial damage NTSB CHI78FET08Accident · Minor injuriesClosedPiper PA-28 · South Bend, INJan 21, 1978 · N15764 · Substantial damage NTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNov 19, 1977 · N3095R · Destroyed NTSB CHI76FEA51Accident · No injuriesClosedPiper PA-28R · Lafayette, INSep 16, 1976 · N100TC · Substantial damage NTSB CHI76FET37Accident · Serious injuriesClosedPiper PA-28R · Munster, INMay 31, 1976 · N56639 · Substantial damage NTSB CHI76DEA21Accident · No injuriesClosedPiper PA-28 · Zionsville, INDec 22, 1975 · N1334T · Substantial damage NTSB CHI74AC010Accident · 1 fatalClosedPiper PA-28R · Fountaintown, INAug 1, 1973 · N2102T · Destroyed NTSB CHI72FET29Accident · Minor injuriesClosedPiper PA-28R · Mentone, INMay 21, 1972 · N9346N · Substantial damage