OpenAirDocs.org

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

9 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.

Cases per year

19692026

Where

Open the map

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1999
    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.

NTSB FTW00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bogalusa, LAThe total loss of engine power as a result of water contamination in the fuel system.Oct 30, 1999 · N2654T · Substantial damageNTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.Oct 8, 1999 · N56094 · Substantial damageNTSB ANC99FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Chitina, AKUndetermined.Aug 18, 1999 · N56877 · DestroyedNTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).Aug 16, 1999 · N2721R · Substantial damageNTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.Aug 6, 1999 · N56718 · DestroyedNTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.Jul 14, 1999 · N56706 · Substantial damageNTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.Jul 4, 1999 · N1996T · Substantial damageNTSB LAX99FA214Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Bass Lake, CAInadequate in-flight planning and decision making resulted in a failure to maintain clearance from terrain. A factor in the accident was the pilot's low total time and lack of experience in this make and model of airplane.Jun 18, 1999 · N2706R · DestroyedNTSB MIA99FA172Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cape Canaveral, FLThe pilot's VFR flight into Instrument meteorological conditions and his subsequent failure to maintain control of the aircraft resulting in overload and separation of both wings. Contributing factors were the pilot's failure to obtain a preflight and…Jun 10, 1999 · N56192 · Destroyed