Fatal NTSB investigations: Piper PA-28-140, GA
19 cases on aircraft the registry lists as Piper PA-28-140. 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
| 1968 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2005 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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" = 'GA' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…NTSB ATL93FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stone Mountain, GAThe pilot-in-command's improper use of the aircraft stabilator during the takeoff, and his failure to maintain airspeed, which resulted in an inadvertant stall. A factor was the high obstructions (trees) located near the departure end of the runway.NTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.NTSB ATL90FA093Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Ellijay, GAThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions.NTSB ATL85FA179Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Kennesaw, GAPrior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and…NTSB ATL82FA233Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Folkston, GAThe acft crashed into the okefenokee swamp in se Georgia. Thunderstorms, varying in magnitude from levels 3 to 5, were moving from west of jacksonville FL to an area north of the okefenoke swamp. The storms were moving nw at 20K.NTSB ATL82FA017Accident · 1 fatalClosedPiper PA-28 · Savannah, GANTSB MIA79FA112Accident · 1 fatalClosedPiper PA-28 · Canton, GANTSB MIA78DA045Accident · 4 fatalClosedPiper PA-28 · Jekyll Island, GANTSB MIA77FA005Accident · 2 fatalClosedPiper PA-28 · Brunswick, GANTSB MIA74AM093Accident · 2 fatalClosedPiper PA-28 · Folkston, GANTSB MIA74AM060Accident · 2 fatalClosedPiper PA-28 · Waleska, GANTSB MIA73AM114Accident · 1 fatalClosedPiper PA-28 · Mableton, GANTSB MIA73AM024Accident · 2 fatalClosedPiper PA-28 · Alma, GANTSB MIA72AM127Accident · 1 fatalClosedPiper PA-28 · Statesboro, GANTSB MIA72AM029Accident · 1 fatalClosedPiper PA-28 · Augusta, GANTSB MIA71AM046Accident · 2 fatalClosedPiper PA-28 · Blakely, GANTSB MIA71AM010Accident · 4 fatalClosedPiper PA-28 · Brunswick, GANTSB MIA69A0014Accident · 1 fatalClosedPiper PA-28 · Snellville, GA