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 SEA97LA004Accident · No injuriesLimited investigationFinal reportCrouch Avid Mark IV · Stanwood, WAfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of engine power. A factor relating to the accident was: the pilot's failure to attain the proper touchdown point on suitable terrain during the…Oct 6, 1996 · N518DC · Substantial damageNTSB NYC97LA003Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Mansfield, MAfailure of the T-6 pilot to maintain clearance from the Cessna 152, as he turned off the runway after landing. A factor relating to the accident was: the T-6 pilot's restricted view of the Cessna 152 (lack of visual detection), due to a blind spot beyond the…Oct 6, 1996 · N5115D · 2 aircraft · Substantial damageNTSB LAX97LA005Accident · No injuriesLimited investigationFinal reportNorth American F-86 · Salinas, CAan internal failure of a hydraulic pump, which resulted in contamination in the hydraulic system and subsequent loss of the braking system. Factors related to the accident included the proximity of a fence and rough/uneven terrain adjacent to the runway.Oct 6, 1996 · N186SE · Substantial damageNTSB LAX97LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Ely, NVa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed to preclude stalling, while turning toward an emergency landing area. A factor related to the accident was: the high density altitude condition.Oct 6, 1996 · N6614J · DestroyedNTSB IAD97LA004Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Krosno KR-03A · Kutztown, PAthe glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…Oct 6, 1996 · N288S · Substantial damageNTSB FTW97LA022Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 90 · Albuquerque, NMThe passenger's failure to follow instructions for disembarking.Oct 6, 1996 · GJNNB · No damageNTSB CHI97LA004Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Nunda, SDfailure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.Oct 6, 1996 · N7925J · Substantial damageNTSB SEA97FA003Accident · No injuriesField investigationFinal reportEnstrom F-28C · Spokane, WAa loss of engine power for undetermined reasons.Oct 5, 1996 · N574H · Substantial damageNTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.Oct 5, 1996 · N3707R · Substantial damageNTSB LAX97FA003Accident · 4 fatalField investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot's inadequate preflight planning and preparation, which resulted in an inability to outclimb rising/wooded terrain after takeoff. Factors relating to the accident were: failure of the pilot to ensure that the aircraft's gross weight was not exceed…Oct 5, 1996 · N6267R · DestroyedNTSB IAD97LA003Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Mahopac, NYthe pilot's failure to maintain directional control during takeoff, which resulted in a inflight collision with trees (sapplings). A factor related to the accident was: the quartering tailwind that was encountered during takeoff.Oct 5, 1996 · N6124Q · Substantial damageNTSB IAD97LA002Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunbury, PAfailure of the cluster gear attaching bolts (of which one failed from fatigue), resulting in a disconnect of the gear and loss of engine power. An obstruction (rock) in the emergency landing area was a related factor.Oct 5, 1996 · N6741S · Substantial damageNTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.Oct 5, 1996 · N47AV · No damageNTSB FTW97LA008Accident · No injuriesLimited investigationFinal reportCessna 172M · Tuttle, OKfailure of the pilot to maintain directional control during takeoff roll, which resulted in a ground swerve. Factors relating to the accident were: tall grass along the edges of the runway, and the proximity of the fence, fence posts, and trees.Oct 5, 1996 · N172JF · Substantial damageNTSB FTW97LA007Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Elk City, OKThe loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.Oct 5, 1996 · N3179K · Substantial damageNTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.Oct 5, 1996 · N5749H · DestroyedNTSB SEA97LA002Accident · No injuriesLimited investigationFinal reportRockwell S2R · Glide, ORfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of power. Factors relating to the accident were: false indications of cockpit fuel gauges and unsuitable terrain for a forced landing.Oct 4, 1996 · N8957Q · Substantial damageNTSB SEA97FA001Accident · 3 fatalField investigationFinal reportBoeing Vertol BV-107 II · Canby, ORfailure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…Oct 4, 1996 · N196CH · DestroyedNTSB NYC97LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Coudersport, PAthe pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.Oct 4, 1996 · N5154E · DestroyedNTSB MIA97LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartsville, SCThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an inadvertent stall, and subsequent in-flight collision with terrain and nose over.Oct 4, 1996 · N94526 · Substantial damageNTSB FTW97LA009Accident · Serious injuriesLimited investigationFinal reportYoung Cozy MK IV · Pueblo, COthe pilot/builder's improper design change which resulted in a loss of control following an intentional stall. A factor was an erroneous weight-and-balance calculation.Oct 4, 1996 · N96PJ · Substantial damageNTSB FTW97LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Colorado Spgs, COthe student pilot attempting to exit the runway onto a taxiway at excessive speed. A factor was the pilot's failure to land the aircraft in the proper touchdown zone.Oct 4, 1996 · N25772 · Substantial damageNTSB FTW97LA004Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-59 · Sterling, COLoss of control when the pilot exceeded the velocity of stall while in a turn.Oct 4, 1996 · N597R · Substantial damageNTSB FTW97IA003Incident · No injuriesIncident investigationFinal reportBeech 1900D · Pueblo, COPartial incapacitation of the flightcrew for unknown reasons.Oct 4, 1996 · N154ZV · No damageNTSB LAX97LA008Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Kona, HIloss of engine power for undetermined reason(s).Oct 3, 1996 · N1365R · DestroyedNTSB LAX97LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Plymouth, CAfailure of the #3 exhaust valve, which resulted in loss of engine power, a forced landing, and subsequent collision with a fence post.Oct 3, 1996 · N5705U · Substantial damageNTSB CHI97LA002Accident · No injuriesLimited investigationFinal reportCessna 185 · Finley, NDfailure of the flight instructor (CFI) to ensure that clearance from the dock was maintained, while starting to taxi. The crosswind was a related factor.Oct 3, 1996 · N185ND · Substantial damageNTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.Oct 3, 1996 · N5393C · Substantial damageNTSB ANC97LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Ashton, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the crosswind and wind gusts.Oct 3, 1996 · N2821P · Substantial damageNTSB MIA97LA001Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Jackson, MSthe pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.Oct 2, 1996 · N4178S · Substantial damageNTSB IAD97FA001Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Brandywine, MDThe pilots failure to maintain his assigned altitude in IFR conditions. A related factor was the failure of the radar controller to prevent the descent of N2881W to an altitude below the minimum vectoring altitude. Additionally, the controller's failure to…Oct 2, 1996 · N2881W · DestroyedNTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.Oct 2, 1996 · N145DB · DestroyedNTSB DCA97RA001Accident · 70 fatalForeign investigationBoeing B-757-23A · Lima, PeruOct 2, 1996 · N52AWNTSB ANC97FA002Accident · 1 fatalField investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's inadequate compensation for wind conditions and failure to maintain adequate airspeed, which resulted in an inadvertent stall. The unfavorable wind condition was a related factor.Oct 2, 1996 · N64RS · DestroyedNTSB SEA96LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar City, UTthe pilot's failure to attain proper airspeed during takeoff, which resulted in a premature lift-off and an encounter with the terrain during the aborted landing. Excessive extension of the wing flaps was a related factor.Oct 1, 1996 · N5459H · Substantial damageNTSB FTW97LA001Accident · Serious injuriesLimited investigationFinal reportContinental Copters EL Tomcat MK-5A · Lafayette, LAthe pilot's failure to ensure a proper preflight and the groundcrew's failure to remove the tiedown. Factors were pilot and groundcrew fatigue.Oct 1, 1996 · N7MH · Substantial damageNTSB MIA96TA236Accident · No injuriesFinal reportBell 206B III · Flamingo, FLthe wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.Sep 30, 1996 · N2113Z · Substantial damageNTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.Sep 30, 1996 · N59576 · Substantial damageNTSB IAD96LA155Accident · Serious injuriesLimited investigationFinal reportMerritt Acro Sport II · Cumberland, MDThe pilot's failure to select the electric fuel boost pump during take off which resulted in loss of engine power due to fuel starvation and the subsequent forced landing. A factor to this accident was the owner/builder alteration of the fuel system by…Sep 30, 1996 · N30803 · Substantial damageNTSB FTW96LA405Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Aspen, COfailure of the right brake antiskid, due to corrosion of a canon plug; and failure of the flight crew to revert to the normal brake system.Sep 30, 1996 · N419MK · Substantial damageNTSB FTW96LA404Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Santa Fe, NMThe pilot's failure to obtain/maintain airspeed resulting in an inadvertent stall/mush. Factors were the high density altitude and the lack of suitable terrain for the landing.Sep 30, 1996 · N6103K · Substantial damageNTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).Sep 30, 1996 · N6008H · Substantial damageNTSB MIA96LA235Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Borinquen, PRthe pilot failed to maintain control of the aircraft while hover taxing. Factors in this accident were wind gusts and a tailwind.Sep 29, 1996 · N1397X · Substantial damageNTSB CHI96LA354Accident · No injuriesLimited investigationFinal reportCessna 172L · Delavan, WIthe pilot's failure to assure the airplane was properly secured prior to hand-propping the engine.Sep 29, 1996 · N7216Q · Substantial damageNTSB ANC96LA168Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKthe pilot's inadequate compensation for wind conditions. The gusty wind was a related factor.Sep 29, 1996 · N94DG · Substantial damageNTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.Sep 28, 1996 · N211KF · Substantial damageNTSB NYC96LA189Accident · No injuriesLimited investigationFinal reportCessna 172K · Deal, NJthe pilot's improper decision/planning, which resulted in fuel exhaustion and a subsequent forced landing.Sep 28, 1996 · N84593 · Substantial damageNTSB NYC96LA188Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-30 · Chillicothe, OHfailure of the pilot to follow the published emergency procedures after loss of power in the left engine. Factors relating to the accident were: fatigue failure of the left torque sensor and gear assembly, which resulted in the loss of engine power, failure…Sep 28, 1996 · N618BB · Substantial damageNTSB FTW96LA403Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COthe pilot-in-command's failure to use proper procedures and engage the turbochargers for takeoff from a high altitude airport. A factor was the high density altitude.Sep 28, 1996 · N37P · Substantial damageNTSB ANC96LA165Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKfailure of the pilot to maintain proper alignment of the selected landing area. Subsequent encounter with rocks was a related factor.Sep 28, 1996 · N222WH · Substantial damage