NTSB investigations, 2012
19 cases where NTSB found Operating environment.
Cases per year
| 2008 | 73 |
|---|---|
| 2009 | 19 |
| 2010 | 19 |
| 2011 | 12 |
| 2012 | 19 |
| 2013 | 13 |
| 2014 | 19 |
| 2015 | 17 |
| 2016 | 13 |
| 2017 | 10 |
| 2018 | 5 |
| 2019 | 10 |
| 2020 | 4 |
| 2021 | 13 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 11 |
| 2025 | 10 |
| 2026 | 4 |
Where
Open the mapLatest 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\", '0301'))
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", '0301')) 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 CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…NTSB WPR13GA044Accident · Minor injuriesFinal reportBell OH-58 · Altadena, CAThe landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…NTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…NTSB ERA13LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Sevierville, TNThe air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…NTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.NTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.NTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.NTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.NTSB CEN12LA459Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Wisner, LAThe pilot’s inadequate takeoff planning that did not consider the reduced acceleration due to a rough, turf runway and his use of an improper flap setting, which resulted in a collision with terrain during takeoff.NTSB WPR12CA310Accident · No injuriesData collectionFinal reportPiper PA-46 · Delano, CAThe pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…NTSB ANC12CA048Accident · No injuriesData collectionFinal reportCessna 207A · Platinum, AKThe pilot inadvertently taxied the airplane into a ditch.NTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…NTSB ERA12FA327Accident · 2 fatalField investigationFinal reportMooney M20J · Sterling, PAThe pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.NTSB WPR12FA184Accident · 3 fatalField investigationFinal reportCessna A185F · Blanding, UTThe pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.NTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.NTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.