NTSB investigations: Piper PA-28R-200, AL
13 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 2000 | 1 |
| 2002 | 2 |
| 2022 | 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\" = 'AL' 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" = 'AL' 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 ERA22LA417Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Meridianville, ALA loss of engine power that could not be determined based on the available evidence.NTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.NTSB MIA02LA175Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Irvington, ALThe loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…NTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.NTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.NTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…NTSB ATL87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Maxwell Afb, ALDuring the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure.NTSB ATL86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hanceville, ALWhile enroute to birmingham the pilot experienced a complete power failure when no. 2 cylinder separated from the engine assembly. The pilot attempted to make an emergency landing on interstate 65 near Hanceville, AL, and the aircraftcollided with an…NTSB MIA78FKJ95Accident · Minor injuriesClosedPiper PA-28R · Huntsville, ALNTSB MIA78FKJ63Accident · Serious injuriesClosedPiper PA-28R · Tuscaloosa, ALNTSB MIA76AM075Accident · 2 fatalClosedPiper PA-28R · Montgomery, ALNTSB MIA76DKJ17Accident · No injuriesClosedPiper PA-28R · Selma, ALNTSB MIA74DKJ27Accident · No injuriesClosedPiper PA-28R · Tuscaloosa, AL