NTSB investigations, 2012
14 cases where NTSB found Use of equip/info, general.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 11 |
| 2010 | 11 |
| 2011 | 13 |
| 2012 | 14 |
| 2013 | 12 |
| 2014 | 3 |
| 2015 | 6 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 7 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 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 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\", '02063000'))
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", '02063000')) 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 CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB CEN12LA649Accident · No injuriesLimited investigationFinal reportBeechcraft A23-24 · Tell City, INThe pilot’s improper touchdown point during landing and the resultant runway excursion during the aborted landing.NTSB WPR12CA351Accident · Minor injuriesData collectionFinal reportRobinson R22 · Monticello, UTThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…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 ANC12FA083Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Hoonah, AKThe pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions.NTSB ERA12LA450Accident · No injuriesLimited investigationFinal reportBeech A36 · Johns Island, SCThe pilot's failure to complete the manual emergency gear extension after a loss of electrical power. Contributing to the accident was the pilot's decision to delegate the landing gear extension to a non-pilot-rated passenger.NTSB CEN12CA396Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valparaiso, INThe pilot’s failure to stop the airplane while taxiing to park, which resulted in a collision with a parked vehicle.NTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…NTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.NTSB ERA12LA356Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · Hallandale, FLThe failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…NTSB CEN12FA311Accident · 1 fatalField investigationFinal reportCessna T210L · Boyd, TXThe pilot’s delayed initiation of a go-around and early retraction of the flaps during the maneuver, which resulted in a collision with trees.NTSB WPR12LA178Accident · Serious injuriesLimited investigationFinal reportBeechcraft A36TC · Pendleton, ORThe pilot's failure to maintain an adequate glidepath for landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's failure to secure the left-side fuel cap before departure. Contributing to the…NTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…