NTSB investigations: Piper PA-28-160, FL
10 cases on aircraft the registry lists as Piper PA-28-160. 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 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\" = 'FL' 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 ('7102806'))
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" = 'FL' 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 ('7102806'))
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 MIA95FA100Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · St. Petersburg, FLThe failure of the pilot to extend wing flaps and maintain airspeed while on approach to land resulting in an inadvertent stall, spin, and uncontrolled descent until collision with a residence and the ground.NTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.NTSB MIA89FA108Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Holley, FLContinued flight by the plt into adverse wx, followed by spatial disorientation and loss of aircraft control. Lack of a preflight weather briefing, weather conditions, and lack of visual cues at night were considered contributing factors.NTSB MIA85LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Daytona Beach, FLThe student plt had been practicing touch and go landings. On his third landing, he permitted too steep an apch and the nose gear contacted the rwy prior to the main gear. A porpoising action then developed which was not arrested prior to failure of the nose…NTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNTSB MIA76FLD02Accident · Minor injuriesClosedPiper PA-28 · Ruskin, FLNTSB MIA75DLD36Accident · No injuriesClosedPiper PA-28 · Wauchula, FLNTSB MIA69F0456Accident · No injuriesClosedPiper PA-28 · Crystal River, FLNTSB MIA69D0289Accident · No injuriesClosedPiper PA-28 · Hernando, FLNTSB MIA66F0077Accident · No injuriesClosedPiper PA-28 · Tallahassee, FL