NTSB investigations: Piper PA-28R-200, NE
14 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
| 1970 | 2 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 2 |
| 1980 | 1 |
| 1993 | 3 |
| 1997 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'NE' 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" = 'NE' 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" DESCRun 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 CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CHI98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Nebraska City, NEthe pilot's improper positioning of the fuel slector to a tank which contained only unusable fuel.NTSB CHI93LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Millard, NEImproper maintenance/inspection of the aircraft by (other) maintenance personnel, and subsequent blockage of the induction air system by an object (alternate air door) that was not removed during previous maintenance.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.NTSB MKC80FA049Accident · Serious injuriesClosedPiper PA-28R · Omaha, NENTSB MKC78FCJ44Accident · No injuriesClosedPiper PA-28R · Humboldt, NENTSB MKC78FCJ22Accident · No injuriesClosedPiper PA-28R · Scottsbluff, NENTSB MKC76DCJ26Accident · Minor injuriesClosedPiper PA-28R · Lexington, NENTSB MKC76FCJ22Accident · No injuriesClosedPiper PA-28R · Brule, NENTSB MKC75DCJ22Accident · No injuriesClosedPiper PA-25 · Bristow, NENTSB MKC73AK013Accident · 2 fatalClosedPiper PA-28R · Lincoln, NENTSB MKC71AK019Accident · 1 fatalClosedPiper PA-28R · Sidney, NENTSB MKC71FCJ03Accident · No injuriesClosedPiper PA-28R · Deshler, NE