NTSB investigations, 2008
87 cases where NTSB found Experience/knowledge.
Cases per year
| 2008 | 87 |
|---|---|
| 2009 | 79 |
| 2010 | 77 |
| 2011 | 78 |
| 2012 | 89 |
| 2013 | 71 |
| 2014 | 66 |
| 2015 | 64 |
| 2016 | 62 |
| 2017 | 60 |
| 2018 | 54 |
| 2019 | 60 |
| 2020 | 35 |
| 2021 | 38 |
| 2022 | 45 |
| 2023 | 47 |
| 2024 | 46 |
| 2025 | 21 |
| 2026 | 12 |
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\", '0203'))
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", '0203')) 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 ERA09CA127Accident · No injuriesData collectionFinal reportCessna 180K · Port Orange, FLThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident were the gusting wind conditions and the pilot's lack of experience in the make and model airplane.NTSB WPR09LA056Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lompoc, CAThe pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.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 WPR09LA052Accident · Serious injuriesLimited investigationFinal reportAdkins Ridge Runner II · Mulino, ORThe pilot's failure to attain an adequate airspeed that resulted in a stall/mush during the initial climb. Contributing to the accident were the pilot's lack of experience in this make and model airplane and the improper adjustment of the propeller pitch.NTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.NTSB CEN09LA075Accident · Minor injuriesLimited investigationFinal reportHauser U/Hauser J KIT FOX CL · Boulder, COA loss of engine thrust due to the pilot's inadvertent activation of the propeller controls. Contributing to the accident were the non-standard propeller controls and the pilot's lack of experience in the airplane.NTSB CEN09FA070Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Marshfield, WIThe pilot's failure to maintain control of the airplane during final approach for landing in night, visual meteorological conditions for undetermined reasons.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 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 ERA09CA045Accident · No injuriesData collectionFinal reportRandall Amanda Rotorway · Middletown, DEThe student pilot’s excessive use of cyclic during the engine run-up. Contributing to the accident were the student pilot’s lack of overall experience and the gusting wind conditions.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB ERA09LA026Accident · Serious injuriesLimited investigationFinal reportCessna 175A · Foley, ALThe pilot’s failure to maintain adequate airspeed during initial climb, resulting in a stall and collision with terrain. Contributing to the accident was the pilot’s lack of recent experience.NTSB CEN09CA028Accident · No injuriesData collectionFinal reportHoward Super Sky Raider · Tuscola, ILThe pilot failed to maintain directional control during takeoff roll. A contributing factor was the cornfield and the pilot's lack of recent experience.NTSB ERA09LA019Accident · 1 fatalLimited investigationFinal reportHargett Sky Ranger II · Rock Hill, SCThe non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.NTSB ERA09LA013Accident · 1 fatalLimited investigationFinal reportSabre Tukan · Mohawk, TNThe pilot's loss of control in flight due to a lack of flight experience or instruction. Contributing to the accident was the pilot's impairment due to the recent use of marijuana and a prescription painkiller.NTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB ANC09FA003Accident · 1 fatalField investigationFinal reportAntonovich Anton B Challenger II · Chugiak, AKThe pilot’s failure to maintain control of the airplane while maneuvering, resulting in an in-flight collision with trees. Contributing to the accident was the pilot's lack of experience.NTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…NTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…NTSB MIA08LA205Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA42 · Lancaster, PAThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.NTSB ANC08LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Delta Junction, AKA total loss of engine power during takeoff due to the non-certificated pilot's inadvertent selection of the mixture control instead of the carburetor heat and his lack of training/qualification.NTSB SEA08LA207Accident · Serious injuriesLimited investigationFinal reportSimpson Amphibious Trike · Lake Chelan, WAThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an inadvertent aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the float-equipped, weight-shift airplane.NTSB OPS09IA001Incident · No injuriesIncident investigationFinal reportPeoria, ILThe tower local controller's failure to provide adequate separation between EGF4075 and SKW5961 that landed on intersecting runways.NTSB DEN08CA161AccidentData collectionFinal reportQuicksilver MX II Sprint · Killeen, TXThe operator's failure to maintain clearance from objects during the landing roll. Contributing to the accident was the operator's decision to operate a vehicle for which he/she was not certified.NTSB CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.NTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.NTSB NYC08CA314Accident · No injuriesData collectionFinal reportCessna 172R · Brunswick, GAThe student pilot's improper flare while landing.NTSB DFW08CA229Accident · No injuriesData collectionFinal reportSukhoi SU-31M · Collinsville, OKThe pilot's failure to maintain clearance from marked transmission lines while on final approach.NTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.NTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…NTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…NTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.NTSB DFW08LA217AccidentLimited investigationFinal reportCessna 172A · Albuquerque, NMThe pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.NTSB SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.NTSB DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.NTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.NTSB DEN08LA139Accident · 1 fatalLimited investigationFinal reportDickey RV-6A · Muskogee, OKThe pilot's improper decision to continue flight under visual flight rules into an area of reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was…NTSB DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…NTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…NTSB LAX08PA259Accident · 9 fatalClass 1Final reportSikorsky S-61N · Weaverville, CAThe following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB LAX08FA256Accident · 5 fatalField investigationFinal reportCessna 172K · Gearhart, ORThe pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.NTSB DFW08CA208Accident · No injuriesData collectionFinal reportGroom Sparrow Hawk · Tulsa, OKThe student pilot's failure to maintain control of the gyroplane. Contributing to the accident was the lack of recent flight instruction prior to the flight.NTSB NYC08LA258Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Atlanta, GAThe pilot's improper flare during landing.