NTSB investigations, 2012
79 cases where NTSB found Attention/monitoring.
Cases per year
| 2008 | 102 |
|---|---|
| 2009 | 124 |
| 2010 | 76 |
| 2011 | 86 |
| 2012 | 79 |
| 2013 | 94 |
| 2014 | 97 |
| 2015 | 111 |
| 2016 | 103 |
| 2017 | 106 |
| 2018 | 130 |
| 2019 | 121 |
| 2020 | 83 |
| 2021 | 106 |
| 2022 | 97 |
| 2023 | 102 |
| 2024 | 100 |
| 2025 | 100 |
| 2026 | 46 |
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\", '020215'))
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", '020215')) 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 CEN13LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Grand Isle, NEThe student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.NTSB WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB ERA13CA091Accident · No injuriesData collectionFinal reportPiper PA28R · Newport News, VAThe pilot’s failure to properly monitor the flight controls (toe brake pedals) during engine start.NTSB CEN13IA107Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Williston, NDThe snowplow driver’s failure to ensure that the runway was clear before driving onto it, which resulted in a runway incursion with a departing airplane.NTSB CEN13FA101Accident · No injuriesField investigationFinal reportCessna 501 · Detroit Lakes, MNA loss of airplane control due to an undetermined avionics malfunction and the pilots’ inattention, which resulted in excessive airframe forces during the unusual attitude recovery. The reason for the avionics malfunction could not be determined because…NTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB WPR13TA051Accident · Minor injuriesFinal reportEurocopter AS350B3 2B1 · Newfield, AZThe pilot's distraction while retrieving an item behind him while the helicopter was on the ground with the engine running, which led to his aggressive overapplication of the flight controls after experiencing a ground resonance condition and subsequent loss…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 ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.NTSB WPR13CA031Accident · No injuriesData collectionFinal reportBeech D17S · Van Nuys, CAThe pilot of another airplane did not maintain a proper visual lookout during taxi, which resulted in an on-ground collision.NTSB WPR13IA020Incident · No injuriesIncident investigationFinal reportAgusta A119 · Dolan Springs, AZInsufficient clearance between a truck and the main rotor blades of a helicopter on the ground with the engine running because of the lack of on-scene coordination between the agencies that responded to and were tasked with managing the vehicle accident site.NTSB ERA13CA033Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Newton, GAThe pilot’s failure to maintain clearance from power lines while maneuvering, which resulted in a hard forced landing.NTSB ERA13LA022Accident · No injuriesLimited investigationFinal reportHughes/Helicopter Assocs 369A · West Chester, PAThe pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB ANC12CA111Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Anchorage, AKThe flight instructor's inadequate supervision of the student pilot during a hovering autorotation, which resulted in a dynamic rollover.NTSB ERA12CA579Accident · No injuriesData collectionFinal reportCessna 172P · Richmond, KYThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.NTSB ERA12CA580Accident · No injuriesData collectionFinal reportSikorsky S-76C · Theodore, ALThe pilot's failure to maintain adequate obstacle clearance while taxiing.NTSB WPR12CA435Accident · No injuriesData collectionFinal reportPiper PA24 · Madera, CAThe student's and flight instructor’s failure to ensure that the landing gear was extended prior to landing.NTSB CEN12LA648Accident · No injuriesLimited investigationFinal reportHughes 269A · Mc Cool Junction, NEThe flight instructor’s inadequate supervision of the student pilot’s entry into the autorotation, which resulted in a hard landing. Contributing to the accident was the loss of engine power as a result of the student pilot rapidly lowering the helicopter’s…NTSB WPR12LA428Accident · Minor injuriesLimited investigationFinal reportRockwell International 690A · Ellensburg, WAThe pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.NTSB ERA12CA564Accident · Minor injuriesData collectionFinal reportLancair LC42-550FG · Okeechobee, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12LA562Accident · 1 fatalLimited investigationFinal reportRepublic RC-3 · Cedar Bluff, ALThe pilot's failure to see and avoid power lines during final approach to landing.NTSB CEN12LA629Accident · No injuriesLimited investigationFinal reportVarga 2150A · Clinton, IAThe pilot of the other airplane failing to adequately monitor for other aircraft while landing.NTSB CEN12CA618Accident · No injuriesData collectionFinal reportBeech V35 · Decatur, TXThe pilot's inattention during the landing roll, which resulted in retraction of the landing gear instead of the flaps.NTSB DCA12IA141Incident · No injuriesIncident investigationFinal reportDe Havilland DHC8 · Soldotna, AKan in-flight loss of control due to the flight crew's inattention to airspeed, pitch attitude, and engine power during the climb leading to an aerodynamic stall. Contributing to the incident was the flight crew's failure to recognize and properly recover from…NTSB CEN12FA606Accident · Serious injuriesField investigationFinal reportCessna 421B · Fort Worth, TXThe pilot's failure to maintain airplane control on takeoff, which resulted in an inadvertent stall. Contributing to the accident were the unlatched nose cargo door, the pilot’s diverted attention, and the pilot's mental ability to handle the emergency…NTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.NTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…NTSB WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.NTSB ANC12CA098Accident · No injuriesData collectionFinal reportMaule M-5-210C · Juneau, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, resulting in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB WPR12LA371Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH58 · Escalon, CAThe pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.NTSB ERA12CA516Accident · Serious injuriesData collectionFinal reportBeech A23-19 · West Liberty, KYThe pilot's delayed decision to abort a takeoff, which resulted in a runway excursion.NTSB WPR12LA362Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Spanish Fork, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a hard landing and rollover.NTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.NTSB ANC12CA090Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground loop and runway excursion.NTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.NTSB ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.NTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…NTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.NTSB CEN12CA464Accident · Serious injuriesData collectionFinal reportBertram William J Bertram 2000 · Shiocton, WIThe pilot’s distraction with taking photographs, which resulted in his failure to maintain sufficient altitude to avoid the guy wire.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 CEN12LA453Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Britt, IAThe pilot’s failure to maintain clearance from power transmission lines during an agricultural application operation. Contributing to the accident was the pilot’s distracted attention due to personal cell phone use during flight operations.NTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.NTSB CEN12LA443Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Red Oak, IAThe pilot's failure to maintain clearance from the ground-support vehicle during landing.