NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 ERA09RA161Accident · 2 fatalForeign investigationCessna 650 · Rome, ItalyNone.NTSB ERA09CA160Accident · No injuriesData collectionFinal reportCessna 172M · Le Roy, NYThe pilot's inadequate compensation for a crosswind during an aborted landing. Contributing to the accident was the pilot's decision to land in gusting crosswinds in excess of the manufacturer's recommended crosswind limit.NTSB ERA09CA159Accident · No injuriesData collectionFinal reportCessna 170B · Lake Placid, FLThe pilot's failure to maintain directional control during the landing. Contributing was the flight instructor's delayed remedial action.NTSB CEN09IA161Incident · No injuriesIncident investigationFinal reportPiper PA28 · Fairmont, NEBoth pilots' failure to see and avoid the other aircraft.NTSB CEN09CA166Accident · No injuriesData collectionFinal reportPiper PA-28 · Terrell, TXThe commercial pilot's failure to maintain adequate airspeed during the approach which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.NTSB ANC09LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Atmautluak, AKThe pilot's failure to maintain adequate airspeed while landing in gusty winds, which resulted in an aerodynamic stall; his improper aircraft weight calculations; and his operation of the airplane over the allowable gross weight limit.NTSB WPR09FA112Accident · 3 fatalField investigationFinal reportBeech A36 · Avalon, CAThe pilot’s failure to follow the published instrument departure procedures during the climb to cruise, and loss of control in instrument meteorological conditions. Contributing to the accident was the pilot’s lack of total experience in instrument…NTSB ERA09CA162Accident · Minor injuriesData collectionFinal reportDavis Sonex · Crossville, TNA total loss of engine power during initial climb due to the failure of the ignition power supply as a result of the improper installation of the electronic control unit.NTSB CEN09CA157Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Cypress, TXThe student pilot's failure to maintain adequate main rotor rpm and the instructor's delayed remedial action.NTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.NTSB CEN09WA309Accident · No injuriesForeign investigationLearjet 35 · Ciudad Victoria, MexicoOn February 5, 2009 a Learjet 35 airplane lost control on landing at Ciudad Victoria Airport (MMCV), Ciudad Victoria, Tamaulipas, Mexico. The crew lost control after touchdown and slid off the runway into the grass and came to rest upright after a 180 degree…NTSB WPR09LA108Accident · No injuriesLimited investigationFinal reportDouglas DC-3/65AR · Mojave, CAThe student pilot failed to follow the checklist and set the takeoff trim properly prior to takeoff resulting in a loss of directional control. Contributing to the accident were the certified flight instructor's inadequate supervision and delayed remedial…NTSB WPR09CA110Accident · No injuriesData collectionFinal reportErcoupe 415D · Whitehall, MTThe pilot's failure to attain the proper touchdown point and his failure to abort the landing.NTSB CEN09IA153Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-500T · Aspen, COThe pilot's inability to maintain directional control of the airplane during landing for undetermined reasons.NTSB ERA09CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor's improper remedial action following the student pilot's loss of control. Contributing to the accident was the student pilot's loss of control.NTSB CEN09CA169Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mineral Wells, TXThe failure of the airframe and power plant mechanic to ensure proper lubrication of wire cables in the landing gear system during the annual inspection which precluded safe operation of the landing gear system.NTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.NTSB CEN09WA160Accident · No injuriesForeign investigationBell OH-58 · Dominican RepublicOn February 2, 2009, about 1745 Coordinated Universal Time (UTC), a single-engine Bell helicopter, registration HI-855, impacted terrain after a loss of engine power, while do agricultural application work in the southwest section of Dominican Republic. The…NTSB WPR09CA106Accident · No injuriesData collectionFinal reportGrumman AA-5 · Payson, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control. Contributing to the accident was the crosswind condition.NTSB WPR09CA105Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Bountiful, UTThe pilot's improper decision to fly at low altitude while maneuvering in mountainous terrain in a canyon and inadvertently exceeding the climb capability of the helicopter. Contributing to the accident were a high density altitude, mountainous terrain, and a…NTSB ERA09WA211Accident · 3 fatalForeign investigationPiper PA-28R · Santo Antonio do Leverger, BrazilNone.NTSB ERA09LA152Accident · 2 fatalLimited investigationFinal reportPiper PA-18 -150 · Tallahassee, FLThe pilot's decision to initiate takeoff in close proximity to other vehicles which were operating on the runway resulting in collision with a vehicle during takeoff.NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB ERA09CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lexington, KYThe pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.NTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.NTSB CEN09CA148Accident · No injuriesData collectionFinal reportCessna 172 · Union Mills, INThe certificated flight instructor's failure to follow correct engine clearing procedures. A factor was the unsuitable landing area.NTSB WPR09FA104Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Fillmore, CAAn in-flight break-up while maneuvering as a result of the main rotor blades diverging from the normal plane of rotation and severing the tailboom. The underlying reason for the main rotor divergence could not be determined.NTSB ERA09LA150Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Ellenboro, NCThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot’s lack of experience in the make and model of the airplane.NTSB ERA09LA147Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Moscow, TNThe pilot's initiation of a low altitude maneuver followed by an uncontrolled descent into terrain.NTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.NTSB CEN09LA207Accident · No injuriesLimited investigationFinal reportHall Steven C Lancair LE · Longmont, COThe pilot's failure to maintain aircraft pitch control resulting in the airplane impacting the terrain. Contributing to the accident were the pilot's failure to ensure the canopy was fully locked prior to takeoff and the canopy oscillations in flight.NTSB CEN09LA149Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Cypress, TXBoth pilot's failure to see and avoid the other aircraft.NTSB CEN09FA146Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Menomonie, WIThe pilot's failure to maintain control of the airplane while flying at night in instrument meteorological conditions.NTSB CEN09CA159Accident · Serious injuriesData collectionFinal reportCameron Balloons US V-90 · La Junta, COThe pilot's failure to maintain a safe rate of descent during landing. Contributing to the accident was the strong surface winds.NTSB ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…NTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…NTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…NTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.NTSB WPR09CA103Accident · No injuriesData collectionFinal reportAeronca 7BC · Half Moon Bay, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to perform an accurate visual fuel quantity check prior to initiating the flight.NTSB ERA09FA148Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Moncks Corner, SCA loss of aircraft control during the landing approach for undetermined reasons.NTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.NTSB WPR09LA100Accident · No injuriesLimited investigationFinal reportCessna 210A · Henderson, NVAn undetermined failure of the hydraulic power pack to fully extend the main landing gear through both the normal and emergency systems.NTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…NTSB ERA09LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 112A · Everglades City, FLThe partial loss of engine power for an undetermined reason. Contributing to the accident was the pilot's attempt to continue takeoff with partial engine power.NTSB ERA09FA141Accident · 1 fatalField investigationFinal reportRemos Remos GX · Sebring, FLThe pilot's inadequate preflight assembly and inspection which resulted in the pushrod connection to the left aileron not being connected, which led to a subsequent inflight loss of control and impact with terrain.NTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.NTSB WPR09LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Oceanside, CAA defective alternator wire splice that resulted in an intermittent electrical system malfunction and erroneous fuel gauge readings, and, a loss of engine power for an undetermined reason.