NTSB investigations, 2010, GA
22 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 18 |
| 2010 | 22 |
| 2011 | 22 |
| 2012 | 26 |
| 2013 | 13 |
| 2014 | 21 |
| 2015 | 17 |
| 2016 | 27 |
| 2017 | 17 |
| 2018 | 18 |
| 2019 | 13 |
| 2020 | 6 |
| 2021 | 15 |
| 2022 | 13 |
| 2023 | 16 |
| 2024 | 13 |
| 2025 | 5 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2010
AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2010 AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA11CA077Accident · Serious injuriesData collectionFinal reportAntares MA-33M R582 · Rising Fawn, GAThe student pilot's failure to relinquish control of the weight-shift control aircraft to the certified flight instructor, which resulted in an inadvertent stall.NTSB ERA11LA022Accident · 2 fatalLimited investigationFinal reportNewcomer RV6 · Monticello, GAThe pilot's loss of aircraft control during the initial climb.NTSB ERA11LA014Accident · 1 fatalLimited investigationFinal reportEngineering & Research Ercoupe 415-D · Lawrenceville, GAInadequate maintenance performed on the airplane, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the corrosion within the carburetor.NTSB ERA11LA003Accident · Minor injuriesLimited investigationFinal reportYost Edwin S Glasair SH-2 · Jackson, GAThe pilot's loss of aircraft control for undetermined reasons.NTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…NTSB ERA10LA487Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Dublin, GAThe pilot's failure to properly secure the oil drain plug after changing the engine oil, which resulted in oil starvation and an engine failure during cruise flight.NTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.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 ERA10LA454Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Acworth, GAThe pilots improper in-flight fuel management resulting in a total loss of engine power during a descent due to fuel starvation.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 ERA10LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Eastman, GABoth pilots’ failure to use emergency checklist procedures for restarting the engine after the loss of engine power due to fuel starvation.NTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.NTSB ERA10LA401Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAA total loss of engine power due to a failure of the compressor turbine blades for undetermined reasons.NTSB ERA10CA339Accident · No injuriesData collectionFinal reportPiper J3C-65 · Thomaston, GAThe pilot’s failure to maintain directional control during landing.NTSB ERA10LA314Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sandersville, GAA total loss of engine power for undetermined reasons.NTSB ERA10CA258Accident · Serious injuriesData collectionFinal reportMoynahan Moynahan Pitts S-1S · Newnan, GAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel planning.NTSB ERA10CA265Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Carrollton, GAThe pilot's improper touchdown point during landing. Contributing to the accident was the certificated flight instructor's lack of remedial action.NTSB ERA10CA243Accident · No injuriesData collectionFinal reportGlobe GC-1B · Carollton, GAThe pilot's improper recovery from the bounced landings, resulting in a loss of directional control.NTSB ERA10CA240Accident · No injuriesData collectionFinal reportGrumman G164 · Hampton, GAA total loss of engine power during a go-around due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB ERA10CA230Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Augusta, GAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.