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 CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.NTSB CEN09CA038Accident · No injuriesData collectionFinal reportBeech A36 · Salina, KSThe pilot's failure to properly manage the available fuel supply, which resulted in fuel starvation and subsequent loss of engine power.NTSB CEN09WA022Accident · 3 fatalForeign investigationCessna 402 · Monterrey, MexicoOn October 17, 2008, a Cessna 402C with Mexican Registration XC-HAQ departed on Runway 02 from Del Norte Airport (MMAN), near Monterrey, Nuevo Leon, Mexico at 1308 central daylight time (CDT) and was on climb out to cruise when radar contact was lost at 1315.…NTSB ANC09CA006Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Skwentna, AKThe pilot's selection of unsuitable terrain for landing.NTSB WPR09FA015Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Markleeville, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to choose a suitable landing area.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…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 ERA09FA022Accident · 1 fatalField investigationFinal reportRobinson R22 · Dryden, NYThe pilot's continued visual flight into instrument meteorological conditions which resulted in controlled flight into terrain.NTSB DCA09WA008Accident · No injuriesForeign investigationBoeing 737 · Maiquetia, Venezuela.NTSB CEN09MA019Accident · 4 fatalMajor investigationFinal reportBell 222 · Aurora, ILThe pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…NTSB ERA09LA021Accident · No injuriesLimited investigationFinal reportSteele John J Acro Sport · Madison, NHThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heatNTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.NTSB WPR09LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORAn in-flight engine fire due to the fatigue fracture of an exhaust pipe that resulted from a failure of the pipe's slip joint.NTSB ERA09CA018Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Repton, ALFuel exhaustion due to the pilot's inadequate preflight planning.NTSB WPR09TA012Accident · 1 fatalFinal reportBell 407 · Sedona, AZThe paramedic's failure to monitor and maintain clearance from the rotating main rotor blades after exiting the helicopter.NTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.NTSB CEN09CA017Accident · No injuriesData collectionFinal reportCessna 172P · Delphi, INThe student pilot's failure to maintain separation from a hangar building while taxiing. Contributing to the accident was the hangar building.NTSB WPR09CA011Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Fresno, CAThe pilot's failure to maintain a proper glide path while on final approach.NTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.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 ERA09CA014Accident · Serious injuriesData collectionFinal reportPiper J3C-50 · Epping, NHThe pilot's improper preflight inspection and his decision to fly an unairworthy airplane.NTSB CEN09CA011Accident · No injuriesData collectionFinal reportCessna 170 · Santa Fe, NMThe flight instructor's delay in taking timely control of the airplane. Contributing to the accident was the crosswind.NTSB WPR09LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Placerville, CAThe loss of engine power for undetermined reasons.NTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.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 CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.NTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.NTSB ERA09CA012Accident · Minor injuriesData collectionFinal reportCessna 177 · Bluffton, SCThe pilot's inadequate planning and preflight inspection.NTSB CEN09LA009Accident · 1 fatalLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's failure to maintain clearance from the power lines and the failure of either pilot to take any corrective action to avoid the collision.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB CEN09CA013Accident · Minor injuriesData collectionFinal reportPegasus Quantum · West Terre Haute, INThe pilot's failure to adequately compensate for the crosswind during the go-around. Contributing to the accident was the crosswind condition and the trees.NTSB WPR09CA007Accident · No injuriesData collectionFinal reportCessna T206H · Henderson, NVThe pilot's inadequate compensation for the crosswind conditions.NTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.NTSB ERA09CA011Accident · No injuriesData collectionFinal reportVelocity SE-FG · Chipley, FLThe pilot's inadequate in-flight fuel planning, resulting in loss of engine power due to fuel exhaustion.NTSB CEN09CA006Accident · Minor injuriesData collectionFinal reportBeech 23 · Chesaning, MIThe pilot's failure to adequately compensate for the gusting wind conditions during landing. Contributing to the accident were the gusting winds.NTSB ANC09TA005Accident · No injuriesFinal reportCessna A185F · Kenai, AKThe pilot's failure to maintain clearance from high vegetation while taxiing after landing.NTSB WPR09FA005Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian SKY Arrow 600 · Malibu, CAThe pilot's failure to maintain aircraft control during a low-altitude maneuver. Contributing to the accident was the pilot's decision to perform a maneuver at a low altitude that was insufficient to allow him to recover from the loss of control. Contributing…NTSB CEN09LA014Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe total loss of engine power due to a fracture in the oil filter adapter housing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CEN09IA003Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Weatherford, TXThe failure of the vertical stabilizer control adapter due to reverse bending fatigue.NTSB CEN09CA004Accident · No injuriesData collectionFinal reportCessna 182P · Mount Vernon, MOThe pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.NTSB ANC09LA004Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe failure of both pilots to maintain adequate clearance/distance from each other at the taxiway intersection to avoid a collision. Contributing to the accident was a lack of clear and concise instruction to either airplane by the ground controller to…NTSB ERA09CA017Accident · No injuriesData collectionFinal reportCessna 182T · Manchester, CTThe in-flight collision with a bird.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 DCA09WA005Accident · Serious injuriesForeign investigationAirbus A330 · Learmonth Aerodome, AustraliaOn October 7, 2008, at 12:42 local time, a Qantas Airways Airbus A330-300, registration VH-QPA, experienced an abrupt pitch down maneuver during cruise near the Learmonth Aerodrome. The flight crew diverted to Learmonth, Australia. The flight was a scheduled…NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.