NTSB investigations, 2010
543 cases where NTSB found Action/decision.
Cases per year
| 2008 | 500 |
|---|---|
| 2009 | 446 |
| 2010 | 543 |
| 2011 | 602 |
| 2012 | 544 |
| 2013 | 437 |
| 2014 | 430 |
| 2015 | 337 |
| 2016 | 367 |
| 2017 | 367 |
| 2018 | 346 |
| 2019 | 316 |
| 2020 | 309 |
| 2021 | 369 |
| 2022 | 371 |
| 2023 | 362 |
| 2024 | 297 |
| 2025 | 236 |
| 2026 | 122 |
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\") = 2010
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0204'))
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") = 2010 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0204')) 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 OPS11IA273Incident · No injuriesIncident investigationFinal reportEmbraer ERJ190 · Denver, COThe driver of the operation vehicle's misidentification of the runway for an adjacent taxiway, resulting in a runway incursion with an aircraft in position for takeoff.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.NTSB CEN11CA139Accident · No injuriesData collectionFinal reportCessna 305A · Spooner, WIThe pilot's selection of unsuitable terrain for landing on a snow-covered lake.NTSB ERA11LA099Accident · No injuriesLimited investigationFinal reportBeech F35 · Syracuse, NYThe pilot’s failure to maintain adequate airspeed during landing with airframe structural icing, resulting in an aerodynamic stall and subsequent hard landing. Contributing to the accident was the pilot’s continued flight into known icing conditions.NTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.NTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…NTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.NTSB WPR11LA081Accident · No injuriesLimited investigationFinal reportApollo AS-III · Poipu, HIThe pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.NTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…NTSB WPR11CA079Accident · No injuriesData collectionFinal reportMoyes Bailey Microlite · Newberg, ORThe pilot's improper recovery from a dive, which resulted in a loss of control.NTSB CEN11FA125Accident · 1 fatalField investigationFinal reportBeech C24R · Wheeling, ILThe installation of the wrong engine-driven fuel pump, which resulted in a loss of engine power during takeoff, and the pilot's subsequent decision to turn back toward the airport at an insufficient altitude to complete the maneuver. Contributing to the…NTSB CEN11FA124Accident · 2 fatalField investigationFinal reportMooney M20E · Colorado Springs, COThe pilot’s decision to initiate an approach into weather conditions where the ceiling and visibility were below the minimums for the approach and where reported icing existed, in an airplane not certified for flight in icing conditions, and his failure to…NTSB WPR11FA078Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Perris, CAThe pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB DCA11CA014Accident · No injuriesData collectionFinal reportBoeing 737-7H4 · Philadelphia, PAthe failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.NTSB CEN11LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lake Elmo, MNThe pilot's improper fuel management which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the distraction of the cabin depressurization.NTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.NTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.NTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB OPS11IA173Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Covington, KYThe local controller's distraction with a helicopter south of the field.NTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB CEN11LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-47UF · Chicago, ILThe Boeing 747 first officer’s failure to maintain clearance from another airplane while taxiing due to his inadequate judgment of the distance between the airplanes.NTSB WPR11CA072Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Pullman, WAThe pilot's delayed application of carburetor heat while maneuvering, which resulted in a partial loss of engine power.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB WPR11CA060Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Warner Springs, CAThe certified flight instructor's inadequate compensation for the crosswind and delayed remedial action during landing, which resulted in a ground loop.NTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB CEN11LA092Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Madison, WIThe passenger's decision to deplane without assistance despite having a preexisting condition that limited her mobility.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB ERA11CA076Accident · No injuriesData collectionFinal reportBeech 95-C55 · Williston, FLThe pilot's failure to properly configure and confirm the position of the landing gear prior to landing.NTSB CEN11LA078Accident · No injuriesLimited investigationFinal reportSwiezy Glasair SHA · North Little Rock, ARThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and hard landing.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB ERA11CA062Accident · No injuriesData collectionFinal reportCessna 182 · Sevierville, TNThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB WPR11LA049Accident · No injuriesLimited investigationFinal reportMooney M20B · Marana, AZThe pilot did not secure the manual landing gear operating handle, which resulted in the landing gear collapse during the landing roll.