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 CHI07CA212Accident · No injuriesData collectionFinal reportBell 47G-5 · Jesup, IAThe pilot's inability to maintain control of the helicopter when it unexpectedly encountered a whirlwind shortly after takeoff.NTSB ANC07LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Skwentna, AKThe pilot's failure to maintain clearance from a glacier, which resulted in a tail rotor strike during landing, and damage to the helicopter during an emergency descent/landing on rough/uneven terrain. Factors contributing to the accident were variable and…NTSB MIA07FA117Accident · 2 fatalField investigationFinal reportPiper PA-30 · Nichols, FLFailure of the flight crew to maintain minimal controllable airspeed following a total loss of power in the right engine.NTSB LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.NTSB LAX07CA213Accident · Minor injuriesData collectionFinal reportDiamond DA40-G1000 · Strawberry Rese, UTThe pilot failed to maintain adequate terrain clearance. Contributing to the accident was the pilot's decision to turn into upsloping terrain at a low altitude.NTSB LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.NTSB DEN07LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Ulysses, KSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07CA115Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Albuquerque, NMThe pilot's failure to maintain aircraft control during an encounter with the loss of tail rotor effectiveness. Contributing factors were the high density altitude and the power lines.NTSB CHI07LA204Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Edgerton, WIThe reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…NTSB ATL07FA102Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Tyringham, MAThe pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…NTSB NYC07FA159Accident · 2 fatalField investigationFinal reportMooney M20F · Brooks, KYThe pilot's failure to maintain aircraft control during the aborted landing. Contributing to the accident was the exceedance of the airplane's maximum gross weight, and the pilot's inadequate preflight planning.NTSB NYC07CA163Accident · Minor injuriesData collectionFinal reportCessna 182K · Matincus Island, MEAn evasive maneuver to avoid a bird, while on final approach, which resulted in an in-flight collision with trees.NTSB NYC07CA161Accident · No injuriesData collectionFinal reportCessna 182Q · New Haven, CTThe pilot's improper flare which resulted in a hard landing. A factor to the accident was the wind gusts.NTSB MIA07CA122Accident · Serious injuriesData collectionFinal reportBeech B90 · Louisburg, NCThe failure of the jumper to follow procedures.NTSB LAX07TA208Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07LA210Accident · Minor injuriesLimited investigationFinal reportAviation International Rotors CH-54A · Los Olivos, CAThe company mechanic's inadequately performed maintenance and inspection, which resulted in a flight control malfunction and loss of control during takeoff.NTSB LAX07LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe pilot's improper recovery from a bounced landing and his failure to maintain directional control during the landing roll. Contributing to the accident were the operator's inadequate engine maintenance, which precipitated the loss of engine power, the…NTSB LAX07CA214Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Clarksburg, CAThe pilot's inadequate hand-prop starting procedure and failure to secure the airplane.NTSB DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.NTSB DFW07LA164Accident · Serious injuriesLimited investigationFinal reportBoeing B737-800 · McAlester, OKAn in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB DFW07LA152Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Delhi, LAthe pilot's failure to maintain control of the airplane while practicing aerial application turns over a field.NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.NTSB NYC07LA160Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Berkeley Townsh, NJA loss of engine power during cruise flight for undetermined reasons.NTSB MIA07FA116Accident · No injuriesField investigationFinal reportEurocopter EC 130 B4 · New York, NYThe fatigue fracture and in-flight separation of a 20-inch section of the blue composite main rotor blade trailing edge, aft of the spar, due to inadequate manufacture, and the manufacturer’s subsequent failure to detect an out-of-specification deviation in…NTSB MIA07CA118Accident · No injuriesData collectionFinal reportPiper PA-20-135 · State College, PAThe failure of the pilot to maintain directional control of the airplane.NTSB LAX07FAMS1Accident · 1 fatalMissing aircraftFinal reportCub Crafters CC11-100 · Aurora, ORThe airplane is missing.NTSB LAX07CA223Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Truckee, CAThe pilot's inadequate compensation for a wind gust during landing flare, which resulted in a hard landing.NTSB LAX07CA207Accident · Minor injuriesData collectionFinal reportCessna 170 · Spanaway, WAThe pilot's failure to maintain directional control during an aborted takeoff from a short and narrow runway.NTSB DFW07CA151Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Eldorado, TXThe loss of engine power as result of water contamination due to a faulty seal on the refuel tank port. A contributing factor was t he lack of suitable terrain for the forced landing.NTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA199Accident · Minor injuriesLimited investigationFinal reportHesler Zodiac CH 601 HDS · Jamestown, OHThe loss of engine power during takeoff for undetermined reasons, the pilot not performing an aborted takeoff at the initial recognition of a loss of engine performance, and the stall/mush the pilot encountered after takeoff.NTSB CHI07CA192Accident · No injuriesData collectionFinal reportCessna 150M · Muncie, INThe pilot's failure to maintain sufficient airspeed, resulting in a stall/mush during an attempted aborted landing. A factor in the accident was the premature flare and the pilot's inadequate recovery from a bounced landing.NTSB ANC07LA063Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pedricktown, NJThe first pilot's inadequate preflight inspection, and water contamination of the airplane's fuel system. A factor contributing to the accident was rough/uneven terrain.NTSB ANC07CA061Accident · Minor injuriesData collectionFinal reportCessna 185F · Port Alsworth, AKThe pilot's flight into adverse weather conditions, which resulted in an in-flight collision with terrain while maneuvering. A factor contributing to the accident was interference by the pilot-rated passenger.NTSB OPS07IA007Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York City, NYATC - The incident occurred because the ground controller instructed COM5196 to cross runway 22, without approval from the local controller, resulting in a loss of separation with DAL1238 that was landing on the same runway.NTSB NYC07CA158Accident · No injuriesData collectionFinal reportCessna 195 · Warrenton, VAThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and impact with terrain.NTSB LAX07CA206Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Bridgeport, CAThe pilot's encounter with an unfavorable wind and high sink rate conditions.NTSB LAX07CA205Accident · Minor injuriesData collectionFinal reportSaunders Stiletto · Quartzsite, AZFuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.NTSB DFW07WA159Accident · 9 fatalForeign investigationNorth American T39A · Culiacan, MexicoNTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandNTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB CHI07LA193Accident · No injuriesLimited investigationFinal reportHughes 369D · Comfrey, MNThe loss of engine power due to the loose pressure line during aerial application maneuvers which resulted in a hard forced landing.NTSB LAX07CA203Accident · Serious injuriesData collectionFinal reportRajhamsa Xair · Pima, AZThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional airplane control during landing rollout.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…