NTSB investigations, GA
32 cases where NTSB found Inspection.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 3 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020615'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020615')) 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 ERA25LA010Accident · No injuriesClass 4 · LimitedFinal reportDitsler Paul A Dakota Hawk · Nicklesville, GAThe pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.NTSB ERA24LA006Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Jonesboro, GABoth pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.NTSB ERA22LA291Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Warm Springs, GAThe loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.NTSB ERA22LA167Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Winder, GAMaintenance personnel’s failure to detect the damaged aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and subsequent loss of airplane control.NTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.NTSB ERA21LA024Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Winder, GAMaintenance personnel’s failure to properly secure the engine cooling fan attachment bolts, leading to vibration of the cooling fan, the overextension of the tension belt actuator, the failure of the drive system vee-belts, and the loss of power to the rotor…NTSB ERA18LA168Accident · No injuriesClass 3 · LimitedFinal reportStinson L 5 · Thomson, GAFailure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…NTSB ERA17LA336Accident · No injuriesLimited investigationFinal reportCessna 152 · Winder, GAThe pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.NTSB ERA17LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Homerville, GAA total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.NTSB ERA17FA107Accident · 1 fatalField investigationFinal reportBeech A45 · Climax, GAThe failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.NTSB GAA16CA387Accident · Minor injuriesData collectionFinal reportCessna 182 · Hogansville, GAThe pilot's failure to replace the left fuel cap following the preflight inspection, which resulted in fuel exhaustion, a loss of engine power, an emergency landing, and impact with terrain.NTSB ERA16LA073Accident · No injuriesLimited investigationFinal reportCessna 310 · Kennesaw, GAInadequate inspection and rigging of the landing gear system, which resulted in the subsequent failure and collapse of the left main landing gear during landing.NTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.NTSB ERA14LA098Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Savannah, GAMaintenance personnel’s failure to properly secure the auxiliary power unit service door before returning the airplane to service, which resulted in substantial damage to the rudder.NTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA12LA186Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Jasper, GAThe pilots' inadequate preflight inspection that failed to detect water-contaminated fuel, which resulted in a total loss of engine power.NTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…NTSB ERA11CA419Accident · No injuriesData collectionFinal reportCessna 177 · Americus, GAThe CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11LA142Accident · No injuriesLimited investigationFinal reportKennedy Michael M Lancair 320 · Dawsonville, GAThe pilot’s inadequate preflight inspection and failure to detect water-contaminated fuel, which resulted in a loss of engine power.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.NTSB ERA10LA248Accident · Minor injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-C · LaGrange, GAA loss of engine power due to the pilot's inadequate preflight inspection and his failure to ensure that the fuel tank shut-off valve was open resulting in fuel starvation.NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB ERA10LA053Accident · No injuriesLimited investigationFinal reportHughes 369 · Baxley, GAA loss of engine power due to fuel starvation resulting from the pilot’s inadequate preflight inspection of the main fuel valve position.NTSB ERA09LA257Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAA loss of engine power due to carburetor icing as a result of the maintenance technician's failure to detect and correct the condition of the carburetor heat duct.NTSB MIA08LA187Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlanta, GAThe loss of pitch control due to slippage of the elevator control cable resulting from the maintenance personnel’s improper installation and inspection of the cable.NTSB MIA08LA106Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Hiram, GAThe failure of the starflex arm during engine run-up due to inadequate inspection by maintenance personnel.NTSB NYC08LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Richmond Hill, GAThe loss of engine power during cruise flight due to fuel exhaustion, and the pilot's inadequate preflight inspection.