Fatal NTSB investigations, GA
21 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 3 |
| 1986 | 2 |
| 1989 | 3 |
| 1990 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2006 | 2 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ATL07LA014Accident · 1 fatalLimited investigationFinal reportCarlson Lancair Propjet · Dalton, GAThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. Contributing to the accident was the pilot's mismanagement of the fuel supply, which resulted in loss of engine due to fuel starvation.NTSB ATL06LA069Accident · 1 fatalLimited investigationFinal reportCessna 182B · Gainesville, GAThe pilots improper preflight planning and preparation which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.NTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.NTSB ATL98FA056Accident · 1 fatalField investigationFinal reportJohn S. Hickey Swearingen SX 300 · Thomson, GAThe pilot's inadequate preflight planning of the fuel supply required for the flight that resulted in fuel exhaustion and the loss of engine power.NTSB ATL97FA072Accident · 1 fatalField investigationFinal reportBellanca 14-13 · Stockbridge, GAthe pilot's improper use of carburetor heat, which led to loss of engine power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions, and trees in the emergency landing area.NTSB ATL96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lawrenceville, GAThe pilot's inadequate fuel consumption calculations that resulted in fuel exhaustion. A factor was the pilot's failure to follow the emergency procedure for a forced landing, in that the flaps were not extended.NTSB ATL95FA021Accident · 1 fatalField investigationFinal reportBeech 95B55 · Mableton, GAThe pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB ATL91FA035Accident · 1 fatalField investigationFinal reportBeech B95 · Austell, GAThe loss of engine power which resulted from the pilot's failure to properly use the carburetor heat. The pilot failed to maintain flying speed during the emergency descent which resulted in a stall on final approach. A factor in the accident was weather…NTSB ATL91FA018Accident · 1 fatalField investigationFinal reportCessna 182E · Blairsville, GAFuel exhaustion resulting in engine stoppage, and the pilot's failure to obtain fuel earlier in the flight.NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.NTSB ATL89FA122Accident · 1 fatalField investigationFinal reportCessna 182 · Luthersville, GAPilot's failure to take action that would prevent the formation of carburetor ice. Following the engine malfunction, the pilot did not configure the airplane so as to reduce the severity of the impact, I.e. extend the flaps and slow the airplane. Contributing…NTSB ATL87FA021Accident · 2 fatalField investigationFinal reportCessna 210L · Buford, GAAccording to the operator, cylinders had recently been replaced on the eng & plts had been instructed to operate the eng at 75% power with the mixture richer than normal during a break-in period. On this flt, the plt took off with a full load of fuel. As he…NTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ATL85FA191Accident · 1 fatalField investigationFinal reportPiper J5A · Cleveland, GAThe plt took off from a private strip with his 5 yr old daughter on board. He then made several low passes by a guest house so that his daughter could wave to her grandparents. The acft was last seen headed generally in a northerly direction when it banked…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 ATL83FLA01Accident · 2 fatalFinal reportCessna 172M · 9nm Nw Quitman, GAWitnesses observed the acft a little above the tree tops prior to colliding with a high voltage tension wire. The two passengers (ages 10 & 11) were seated in the right front seat, both using the same seat belt. The surviving passenger stated they had…NTSB ATL82FKG09Accident · 1 fatalFinal reportCessna 210D · Near Commerce, GAThe owner had flown a PA-23 from charlotte to jackson county,FL with another plt following him in N3909Y. The owner stated the other plt was very meticulous & always drained fuel prior to flt. After the 1 hr flt to jackson county, they both looked over the…