NTSB investigations, 2012
10 cases where NTSB found Action/decision, general.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 9 |
| 2011 | 9 |
| 2012 | 10 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2025 | 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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020400'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020400')) 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 CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.NTSB CEN12CA643Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Slaton, TXThe pilot’s misalignment of the helicopter during landing, which resulted in the helicopter’s fall from a raised platform.NTSB CEN12CA647Accident · No injuriesData collectionFinal reportEnstrom F-28A · Fort Worth, TXThe noncertificated pilot's operation of the helicopter, which resulted in the tail boom's contact with the refueling pump.NTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.NTSB WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.NTSB ERA12WA212Accident · 1 fatalForeign investigationCessna 172N · Miranda, VenezuelaOn March 3, 2012, about 1259 universal coordinated time, a Cessna 172N, Venezuelan registration, YV105E, was destroyed when it impacted into terrain while in cruise flight near Municipio Zamora Parroquia Bolivar, Miranda, Venezuela. The pilot was fatally…