NTSB investigations, 2008
500 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\") = 2008
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") = 2008 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 ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB ERA09CA118Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Brunswick, GAThe pilot's failure to maintain control of the airplane during the landing flare. Contributing to the accident were the gusting winds.NTSB ANC09LA017Accident · No injuriesLimited investigationFinal reportCessna 207A · Hoonah, AKThe pilot's failure to ensure that the aft cargo door was properly latched and locked prior to departure, which resulted in an in-flight opening of the aft cargo door and subsequent damage to the airplane.NTSB ERA09CA112Accident · No injuriesData collectionFinal reportMichael Muratore Vans · Bayport, NYThe pilot's failure to stop the airplane within the available runway after touchdown. Contributing to the accident were the failure of the flap system as reported by the pilot and the damp grass.NTSB ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.NTSB ERA09CA110Accident · No injuriesData collectionFinal reportCessna 172R · Morristown, NJThe flight instructor's failure to execute a missed approach when insufficient runway remained for landing. Contributing to the accident were the low ceiling and visibility conditions.NTSB DCA09FA022Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-83 · Los Angeles Intl Airport, CAThe first officer's unannounced advancement of the left engine throttle, which led to a sustained application of high thrust that caused the airplane to impact the tug.NTSB CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.NTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.NTSB CEN09CA118Accident · No injuriesData collectionFinal reportSocata TBM 700 · Clovis, NMThe pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.NTSB ERA09CA103Accident · No injuriesData collectionFinal reportCessna 172 · Corning, NYThe student pilot's failure to maintain directional control during landing. Contributing to the accident were the gusty wind conditions and the flight instructor's delayed remedial action.NTSB DCA09MA021Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-524 · Denver, COThe captain’s cessation of right rudder input, which was needed to maintain directional control of the airplane, about 4 seconds before the excursion, when the airplane encountered a strong and gusty crosswind that exceeded the captain’s training and…NTSB ERA09CA102Accident · Minor injuriesData collectionFinal reportPiper PA-34-200 · Folkston, GAThe student's improper flare and the flight instructor's delayed remedial action.NTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…NTSB ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.NTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.NTSB WPR09CA058Accident · No injuriesData collectionFinal reportCessna 140 · Preston, IDThe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.NTSB CEN09LA095Accident · No injuriesLimited investigationFinal reportCessna 402 · Madison, WIThe pilot’s improper fuel management, which resulted in a loss of engine power during an instrument landing due to fuel exhaustion.NTSB CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB CEN09FA083Accident · 1 fatalField investigationFinal reportCessna 206H · Kalkaska, MIThe pilot's failure to maintain clearance from trees and terrain during the instrument-flight-rules flight. Contributing to the accident was the pilot's failure to comply with instrument flight procedures and his lack of recent instrument flight experience.NTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.NTSB ERA09FA078Accident · 3 fatalField investigationFinal reportRockwell International 690B · Rio Grande, PRThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB WPR09CA055Accident · No injuriesData collectionFinal reportCessna 172RG · Truckee, CAThe pilot misjudged the landing flare resulting in a hard landing.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB CEN09CA077Accident · No injuriesData collectionFinal reportPiper PA-15 · Pleasanton, TXThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB CEN09CA089Accident · No injuriesData collectionFinal reportCessna 182 · Gillespie, ILThe pilot's decision to take off with a known obstacle on the runway.NTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.NTSB WPR09CA080Accident · No injuriesData collectionFinal reportTarantola RV6A · Onalaska, WAThe pilot's improper decision to land with a tailwind, which resulted in the runway overrun. Contributing to the accident was the tailwind.NTSB WPR09CA045Accident · Minor injuriesData collectionFinal reportPiper PA-30 · Kona, HIThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll. Contributing factors were the delayed remedial action by the check pilot, the crosswind condition, and the rough uneven…NTSB ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…NTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.NTSB CEN09CA119Accident · No injuriesData collectionFinal reportPiper Aerostar 6 · Middletown, OHThe pilot's failure to verify that the landing gear was down and locked prior to landing.NTSB CEN09CA068Accident · No injuriesData collectionFinal reportBrantly B-2B · Cedar Hill, TXThe pilot's improper decision to takeoff downwind. A contributing factor was the gusty conditions.NTSB ERA09LA062Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Green Cove Springs, FLThe fusing of an electrical cable from the No. 2 (standby) alternator with the throttle cable resulting in the flight crew’s inability to move the throttle control. Contributing to the accident was the failure of maintenance personnel to detect inadequate…NTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.NTSB CEN09CA067Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Erie, COthe pilot's improper flare during the practice autorotation which resulted in a hard landing. Contributing factors were the flight instructor's delayed remedial action and inadequate supervision.NTSB ERA09CA063Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe student pilot's inadequate compensation for winds during landing.NTSB ERA09CA061Accident · No injuriesData collectionFinal reportCessna 172 · Ft. Lauderdale, FLThe student pilot's improper flare during landing. Contributing to the accident was the student pilot's lack of experience.NTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.NTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.NTSB ERA09FA053Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tallahassee, FLThe pilot's failure to maintain adequate airspeed on final approach, which resulted in a low-altitude aerodynamic stall and spin. Contributing to the accident was the pilot's failure to fly the published instrument approach and his subsequent failure to…NTSB ANC09LA012Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Napaskiak, AKThe pilot's continued flight into adverse weather and icing conditions, and his failure to maintain sufficient airspeed to avoid a stall, resulting in a loss of control and in-flight collision with terrain while on an approach to land.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.NTSB CEN09CA058Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe failure of the pilot to lower the gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB ERA09CA058Accident · No injuriesData collectionFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper flare during landing.NTSB ANC09CA010Accident · No injuriesData collectionFinal reportCessna 172M · Girdwood, AKThe pilot's decision to attempt to take off on a snow-covered runway. Contributing to the accident was the snow-covered runway.