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 CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.NTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.NTSB NYC97LA128Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bellwood, PAthe total loss of engine power due to failed connecting rods.NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.NTSB MIA97LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Walls, MSThe poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…NTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…NTSB FTW97LA233Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Swifton, ARthe pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.NTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.NTSB ANC97IA089Incident · No injuriesIncident investigationFinal reportCessna 185 · Anchorage, AKThe pilot-in-command's failure to retract the landing gear which led to an inadvertent water landing with the amphibian float wheels extended. Associated factors are the pilot's habit interference and the FAA inspector's inadequate monitoring of the flight.NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.NTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.NTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.NTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.NTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.NTSB LAX97LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · San Diego, CAthe pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.NTSB LAX97FA286Accident · 1 fatalField investigationFinal reportCessna 172N · Cuyama, CAundetermined.NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.NTSB ATL97LA089Accident · No injuriesLimited investigationFinal reportCessna 175A · Panama City Bch, FLfailure of the pilot to account for the reduced braking effectiveness on the wet/grass airstrip, which resulted in an overrun and encounter with a ditch. Factors relating to the accident were: failure of the pilot to obtain weather information before…NTSB ANC97LA105Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK-I · Juneau, AKThe pilot's misjudged touchdown which resulted in dragging the right wingtip and rupturing the fuel tank. A factor associated with the accident is the rough water conditions.NTSB ANC97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hoonah, AKThe pilot's failure to maintain directional control while landing.NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.NTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.NTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.NTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.NTSB MIA97WA189Accident · No injuriesForeign investigationAviat A-1 · San Fernando, ArgentinaNTSB MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.NTSB MIA97LA192Accident · 1 fatalLimited investigationFinal reportUnknown Kolb Firestar II · Orlando, FLInadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.NTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…NTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.NTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.NTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…NTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.NTSB CHI97LA177Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.NTSB ANC97LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Prudhoe Bay, AKThe pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.NTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.NTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…NTSB SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.NTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.NTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB LAX97LA218Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The unapproved field modification of the cyclic trim switch, including the use of non-standard parts, which resulted in a hard-over lateral trim failure, and the pilot's subsequent failure to maintain control of the helicopter during a landing approach. A…NTSB LAX97FA217Accident · 3 fatalField investigationFinal reportPiper PA 31-310 · San Diego, CAThe loss of power in the left engine for undetermined reasons and the pilot's subsequent failure to maintain minimum single-engine control airspeed. A contributing factor was the pilot's decision to fly with known deficiencies in the equipment.NTSB FTW97LA231Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Waldenburg, ARthe pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.NTSB DCA97WA067Incident · No injuriesForeign investigationBoeing 737-548 · Copenhagen, DenmarkNTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB ATL97LA087Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Labelle, FLfailure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.