NTSB investigations, 2011
84 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 62 |
|---|---|
| 2009 | 62 |
| 2010 | 79 |
| 2011 | 84 |
| 2012 | 102 |
| 2013 | 78 |
| 2014 | 82 |
| 2015 | 81 |
| 2016 | 120 |
| 2017 | 126 |
| 2018 | 175 |
| 2019 | 124 |
| 2020 | 83 |
| 2021 | 45 |
| 2022 | 55 |
| 2023 | 50 |
| 2024 | 51 |
| 2025 | 69 |
| 2026 | 30 |
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\") = 2011
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' 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") = 2011 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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 CEN12IA123Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Denver, COThe snowplow operator’s incapacitation due to fatigue, which resulted in the snowplow contacting a parked airplane. Contributing to the incident was the company’s lack of a policy regarding employee fatigue.NTSB CEN12WA105Accident · 2 fatalForeign investigationCessna 177A · Ottawa, CanadaOn December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…NTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.NTSB ERA12CA095Accident · No injuriesData collectionFinal reportBell 206L-3 · Wingate, NCThe certified flight instructor did not select an adequate landing site for the practice autorotation.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB ERA12CA082Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brooksville, FLThe pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.NTSB ERA12LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Mulberry, FLThe pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…NTSB WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.NTSB CEN12CA078Accident · No injuriesData collectionFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Carbondale, ILThe main rotor blade’s contact with the vertical stabilizer during the engine shutdown in strong, gusty wind conditions.NTSB ERA12CA291Accident · Serious injuriesData collectionFinal reportNorth American SNJ-6 · Kissimmee, FLThe passenger’s fall from the airplane during a normal egress.NTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.NTSB ERA12CA064Accident · No injuriesData collectionFinal reportStinson 108-3 · Whitefield, NHThe student pilot did not maintain directional control during the landing flare.NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.NTSB CEN12IA050Incident · No injuriesIncident investigationFinal reportNusbaum Vaquero · Hebron, ILThe pilot’s operation of the airplane with known medical conditions and his subsequent heart attack during the flight.NTSB CEN12CA051Accident · Minor injuriesData collectionFinal reportDowner Bellanca 14-19-2 · Borger, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.NTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.NTSB WPR12LA022Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 500D · Colusa, CAA total loss of engine power while maneuvering at low altitude for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. Contributing to the accident severity was the…NTSB OPS12IA041Incident · No injuriesIncident investigationFinal reportCessna 172S · Daytona Beach, FLThe departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…NTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.NTSB ERA12CA020Accident · No injuriesData collectionFinal reportCessna 177B · Honesdale, PAThe pilot’s excessive airspeed during final approach and his delayed decision to abort the landing, resulting in the in-flight collision with trees during the go-around.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB CEN12LA039Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · South Pass 93AImproper centering of the cyclic during a start in gusty wind conditions.NTSB ERA12CA003Accident · Serious injuriesData collectionFinal reportAir Tractor AT-502B · Fort Pierce, FLThe pilot's delayed decision to abort the takeoff.NTSB WPR11FA474Accident · 1 fatalField investigationFinal reportPoe G L/Poe S Y 540 · Chualar, CAThe pilot’s incapacitation due either to g-induced loss of consciousness alone or in combination with a cardiac arrhythmia. Contributing to the accident was the pilot’s use of several medications.NTSB CEN11CA679Accident · No injuriesData collectionFinal reportWaltman Theodore J Moose · Hays, KSRudder flutter due to the design changes to the airplane's horizontal stabilizer.NTSB ERA11FA495Accident · 1 fatalField investigationFinal reportNorth American T-28C · Martinsburg, WVThe pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…NTSB CEN11FA634Accident · 1 fatalField investigationFinal reportRiffel Jerris L RV-7A · Winfield, KSThe pilot’s in-flight loss of control. Contributing to the pilot’s fatal injury was his failure to use the available restraint systems, which resulted in him falling through the open canopy when the airplane inverted.NTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.NTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.NTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.NTSB CEN11LA606Accident · 1 fatalLimited investigationFinal reportBoeing A75N1(PT17) · Mt. Clemens, MIThe wing walker’s decision to release his grip of the airplane during an attempted aerial transfer from airplane to helicopter before both aircraft achieved the proper relative positioning for the transfer.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB ERA11CA478Accident · No injuriesData collectionFinal reportCano Dave Avid Flyer Mkiv · Smithville, TNThe pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.NTSB WPR11LA416Accident · 1 fatalLimited investigationFinal reportLuscombe 8 · Lincoln, CAThe passenger's accidental fall while turning the propeller by hand to start the engine.NTSB ERA11FA462Accident · Serious injuriesField investigationFinal reportBeech B19 · Whitesburg, GAThe student pilot did not retract the wing flaps during a go-around, which decreased the airplane’s climb performance and resulted in an in-flight collision with trees.NTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.NTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.NTSB ERA11CA446Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot's loss of directional control while attempting to close the airplane's door during takeoff roll.NTSB ERA11CA440Accident · Minor injuriesData collectionFinal reportNelsen Lynn H Lightning · Frostproof, FLThe pilot's premature rotation during takeoff.NTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…NTSB CEN11CA526Accident · No injuriesData collectionFinal reportPiper PA-36-375 · Cambridge, NEThe pilot's failure to reset the engine's mixture control lever to the full rich position prior to takeoff.NTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.NTSB CEN11LA527Accident · No injuriesLimited investigationFinal reportSnow Quickie 2 · Ashtabula, OHThe incorrect propeller pitch and lower-than-expected engine speed that did not allow the airplane to attain a proper climb rate during takeoff, and the subsequent hard landing that occurred when the pilot reduced power.NTSB WPR11CA341Accident · No injuriesData collectionFinal reportCliff Starduster II SA300 · San Jose, CAThe pilot's decision to not follow the designated taxiway, and failure to maintain clearance from a sign.NTSB CEN11CA498Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Williams Lake, MIA loss of control during approach due to the front seat passenger's belt buckle being wedged between the rear seat,the rudder pedal and floor board.NTSB CEN11CA495Accident · No injuriesData collectionFinal reportCessna A188B · Greenstown, INThe pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.NTSB WPR11CA337Accident · No injuriesData collectionFinal reportCessna 172N · Porthill, IDThe pilot's failure to maintain clearance from a pole.