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.

NTSB ANC96LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's inadequate compensation for gusty wind conditions during the landing roll. A factor associated with the accident is the gusty wind conditions.Sep 10, 1996 · N6022B · Substantial damageNTSB NYC96LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Closter, NJThe pilot's improper fuel management, which resulted in a power loss due to fuel exhaustion, followed by the airplane striking a tree during a forced landing.Sep 9, 1996 · N1792T · Substantial damageNTSB LAX96LA330Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Warner Springs, CAimproper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…Sep 9, 1996 · N3950B · Substantial damageNTSB ANC96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's selection of unsuitable terrain for taxiing.Sep 9, 1996 · N2989D · Substantial damageNTSB ANC96LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe loss of engine power for an undetermined reason. Factors associated with the accident are the soft terrain and brush in the airstrip overrun area.Sep 9, 1996 · N7909Z · Substantial damageNTSB ANC96LA147Accident · No injuriesLimited investigationFinal reportRans 7 · Anchorage, AKthe pilot's improper recovery from a bounced landing and failure to maintain control of the aircraft. A factor relatated to the accident was: the pilot's improper decision to continue the flight after he identified he was having difficulty landing the…Sep 9, 1996 · N4012H · Substantial damageNTSB LAX96LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Quincy, CAthe pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.Sep 8, 1996 · N97337 · Substantial damageNTSB FTW97LA029Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Stanton, TXPilot's failure to maintain clearance with a wire resulting in the separation of the rudder and a loss of aircraft control.Sep 8, 1996 · N57871 · Substantial damageNTSB FTW96LA379Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Palestine, TXThe pilot's selection of unsuitable terrain for takeoff.Sep 8, 1996 · N7467D · Substantial damageNTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.Sep 8, 1996 · N5401B · Substantial damageNTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.Sep 8, 1996 · N7016T · Substantial damageNTSB CHI96FA332Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Bellaire, MIthe pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.Sep 8, 1996 · N43687 · Substantial damageNTSB ANC96TA148Accident · No injuriesFinal reportPiper PA-18 · Elmendorf, AKloss of engine power due to fuel starvation, which resulted from improper positioning of the fuel tank selector; inadequate supervision by the flight instructor (CFI); and the flight crew's improper emergency procedure.Sep 8, 1996 · N4372A · Substantial damageNTSB ANC96LA152Accident · No injuriesLimited investigationFinal reportCessna 206F · Talkeetna, AKThe disconnection of the nosegear scissors assembly due to the loss of a retainer bolt.Sep 8, 1996 · N9515G · Substantial damageNTSB ANC96LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's improper braking action, which resulted in an inadvertent ground swerve and subsequent damage to the airplane. His excessive airspeed during landing was a related factor.Sep 8, 1996 · N9116D · Substantial damageNTSB ANC96FA149Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Glennallen, AKfailure of the pilot to maintain adequate airspeed, while maneuvering a low altitude, which resulted in an inadvertent stall and an uncontrolled collision with the terrain. A factor related to the accident was: the pilot's use of a medication with sedative…Sep 8, 1996 · N88359 · Substantial damageNTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.Sep 7, 1996 · N12382 · Substantial damageNTSB NYC96FA182Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Frankford Twnsp, NJthe pilot's inadequate preflight planning/preparation by not obtaining a preflight weather briefing, his VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatial disoriented.…Sep 7, 1996 · N422FL · DestroyedNTSB MIA96LA228Accident · Minor injuriesLimited investigationFinal reportCanadair T-33 · Punta Gorda, FLfailure of the pilot to extend the wing flaps for takeoff, and his failure to attain sufficient airspeed for flight with the flaps retracted, which resulted in a stall/mush after lift-off.Sep 7, 1996 · N99195 · Substantial damageNTSB LAX96LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oxnard, CAthe instructor's inadequate supervision of the flight, and his delay in taking the controls and initiating a go-around. The student pilot's failure to maintain runway alignment and the proximity of the runway remaining marker were related factors.Sep 7, 1996 · N41331 · Substantial damageNTSB FTW96LA382Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Edgewood, NMThe pilot's failure to maintain aircraft control. A factor was a whirlwind.Sep 7, 1996 · N9071L · Substantial damageNTSB FTW96LA381Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Biscoe, ARBinding of the flight control system for an undetermined reason.Sep 7, 1996 · N311SM · DestroyedNTSB CHI96LA328Accident · No injuriesLimited investigationFinal reportCessna 182P · Cahokia, ILthe pilot misjudged his planned approach during the precautionary landing and the failed to obtain a proper touchdown point. Factors relating to the accident were: the loose oil filler cap, the uneven terrain on which the landing was made, the runway lights…Sep 7, 1996 · N6590M · Substantial damageNTSB MIA96LA227Accident · No injuriesLimited investigationFinal reportAgusta A109A II · Flamingo, FLThe pilot being unable to stop the helicopter after encounter wet grass after making a precautionary landing in an unlit parking lot following loss of power in one engine and illumination of a transmission chip detector light.Sep 6, 1996 · N169BH · Substantial damageNTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.Sep 6, 1996 · N6632G · Substantial damageNTSB FTW96LA378Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Loreauville, LAThe pilot's inadequate preflight planning/preparation for the flight, resulting in exceeding the maximum gross weight and performance of the helicopter. A factor was the high density altitude.Sep 6, 1996 · N80750 · Substantial damageNTSB FTW96LA377Accident · Serious injuriesLimited investigationFinal reportPzl-Mielec MIG-17 · Amarillo, TXThe pilot's excessive takeoff rotation which led to premature lift-off at a speed inadequate to maintain flight. A factor was the pilot's lack of experience in the MIG-17.Sep 6, 1996 · N1719 · DestroyedNTSB SEA96FA209Accident · 1 fatalField investigationFinal reportCessna 340A · Wise River, MTThe pilot's attempt to fly in adverse meteorological conditions which led a loss of aircraft control. Factors contributing to the accident include: the pilot's failure to obtain the most current information of the meteorological conditions prior to departure,…Sep 5, 1996 · N128RP · DestroyedNTSB MIA96LA226Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · St Clair, ALfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to ground.Sep 5, 1996 · N8563S · DestroyedNTSB LAX96LA328Accident · No injuriesLimited investigationFinal reportCessna 425 · Auburn, CAfailure of the right brake system (master cylinder O-ring seal). Factors relating to the accident were: the narrow runway, and the presence of a ditch adjacent to the runway.Sep 5, 1996 · N425WB · Substantial damageNTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.Sep 5, 1996 · N704QR · Substantial damageNTSB FTW96FA373Accident · 1 fatalField investigationFinal reportBeech D55 · Corsicana, TXThe pilot's failure to maintain minimum control airspeed which resulted in the loss of control. Factors were the bent collar of the left main fuel tank refueling neck which resulted in fuel siphoning from the tank in flight, the pilot's failure to follow…Sep 5, 1996 · N873LB · DestroyedNTSB DCA96MA079Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas DC-10-10CF · Newburgh, NYan in-flight cargo fire of undetermined origin. (NTSB Report AAR-98/03)Sep 5, 1996 · N68055 · DestroyedNTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.Sep 5, 1996 · N2338Z · DestroyedNTSB ANC96LA146Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Iliamna, AKthe pilot's inadequate weather evaluation and inadequate compensation for wind conditions. The adverse weather condition was a related factor.Sep 5, 1996 · N8648V · DestroyedNTSB SEA96TA207Accident · Minor injuriesFinal reportBell 206L-3 · Sheridan, WYthe pilot's improper in-flight planning/decision, concerning maneuvers to position the helicopter for aerial application; and inadvertent loss of tail rotor effectiveness, which resulted in loss of directional control and subsequent collision with the…Sep 4, 1996 · N253EV · Substantial damageNTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.Sep 4, 1996 · N2595N · Substantial damageNTSB CHI96FA330Accident · 1 fatalField investigationFinal reportGreen Castle Avid Flyer Aerobat · Oxford, IAfailure of the private pilot to maintain sufficient airspeed after takeoff, during the initial climb and turn to the crosswind leg; and a delay by the flight instructor (CFI) in taking remedial action to avoid a stall.Sep 4, 1996 · N95GC · DestroyedNTSB ANC96LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Kenai, AKthe pilot's improper fuel managment, which resulted in loss of engine power due to fuel exhaustion.Sep 4, 1996 · N4417P · Substantial damageNTSB MIA96TA221Accident · No injuriesFinal reportBell OH-58A · Wetumpka, ALThe student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.Sep 3, 1996 · N160SA · Substantial damageNTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…Sep 3, 1996 · N53109 · Substantial damageNTSB MIA96LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student pilot's improper recovery from a bounced landing, resulting in a loss of directional control, collapse of the nose gear, and subsequent nose down on the runway.Sep 3, 1996 · N93102 · Substantial damageNTSB LAX96LA325Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Glendale, AZThe loss of engine power due to the pilot's mismanagement of the fuel system, which resulted in fuel starvation. The passenger's action, which restricted the pilot's ability to control the aircraft, was a factor in this accident.Sep 3, 1996 · N99NV · Substantial damageNTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.Sep 3, 1996 · N3166H · Substantial damageNTSB ANC96LA144Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKan in-flight encouter with bird(s)/geese, which resulted in a bird strike.Sep 3, 1996 · N7396U · Substantial damageNTSB ANC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.Sep 3, 1996 · N1801Q · Substantial damageNTSB ANC96LA136Accident · No injuriesLimited investigationFinal reportMaule M-4 · Skwentna, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the rough and uneven terrain.Sep 3, 1996 · N4726T · Substantial damageNTSB ANC96FA141Accident · 3 fatalField investigationFinal reportCessna 172 · Eagle River, AKThe first pilot's failure to maintain sufficient distance/altitude from terrain. A box canyon and mountainous terrain are factors in the accident.Sep 3, 1996 · N8739B · DestroyedNTSB NYC96LA179Accident · No injuriesLimited investigationFinal reportPiper J-3 · Wildwood, NJThe pilot's failure to maintain sufficient altitude during a low altitude maneuver.Sep 2, 1996 · N92085 · Substantial damageNTSB LAX96LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kernville, CAbrake failure due to a stripped brake fitting that allowed the brake fluid to leak out of the system. The failure of maintenance personnel to detect and repair the faulty brake line during the last 100-hour inspection, and the pilot's failure to perform a…Sep 2, 1996 · N5480F · Substantial damage