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 CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.Nov 8, 1999 · N517A · Substantial damageNTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.Nov 8, 1999 · N9927L · Substantial damageNTSB IAD00WA004Accident · 2 fatalForeign investigationHughes 369D · Cologne, GermanyNov 7, 1999 · N1096C · DestroyedNTSB DEN00LA016Accident · No injuriesLimited investigationFinal reportCessna 150E · Longmont, COThe pilot of the other aircraft's failure to follow right-of-way VFR procedures and inadequate visual lookout.Nov 7, 1999 · N6158T · 2 aircraft · Substantial damageNTSB CHI00LA026Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rochester, INthe pilot did not obtain the proper touchdown point. Factors included the closed runway and the culvert.Nov 7, 1999 · N8235M · Substantial damageNTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.Nov 7, 1999 · N9130F · No damageNTSB ATL00FA009Accident · 1 fatalField investigationFinal reportCessna 210N · Chamblee, GAThe failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.Nov 7, 1999 · N7317A · DestroyedNTSB ANC00LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident was snow-covered terrain.Nov 7, 1999 · N8145D · Substantial damageNTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.Nov 6, 1999 · N5490P · Substantial damageNTSB NYC00LA026Accident · Minor injuriesLimited investigationFinal reportBailey Exec 162F · Pottstown, PAThe student pilot's loss of control of the helicopter, his lack of recent experience, his lack of total experience, and his overconfidence in his personal ability. A factor in the accident was the student pilot's disregard of regulations.Nov 6, 1999 · N14JJ · Substantial damageNTSB LAX00TA030Accident · Minor injuriesFinal reportBell OH-58A · La Puente, CAA loss of engine power for undetermined reasons.Nov 6, 1999 · N911RN · DestroyedNTSB DEN00LA015Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Artesia, NMThe pilot's inadequate compensation for the wind conditions.Nov 6, 1999 · N9105Z · No damageNTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.Nov 5, 1999 · N63307 · Substantial damageNTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.Nov 5, 1999 · N714RA · Substantial damageNTSB FTW00LA026Accident · No injuriesLimited investigationFinal reportWaco KNF · Midway, ARThe inability of the pilot to maintain control of the airplane as a result of a downdraft.Nov 5, 1999 · N698N · Substantial damageNTSB DCA00WA007Accident · No injuriesForeign investigationBoeing 777-200 · London, United KingdomNov 5, 1999 · N784UA · Substantial damageNTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.Nov 5, 1999 · N3073V · Substantial damageNTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.Nov 4, 1999 · N164KA · Substantial damageNTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.Nov 3, 1999 · N8515W · Substantial damageNTSB FTW00LA025Accident · Minor injuriesLimited investigationFinal reportStreifthau Baby Great Lakes · Iowa Park, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane.Nov 3, 1999 · N415 · Substantial damageNTSB FTW00LA024Accident · No injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot's failure to maintain clearance with the powerlines.Nov 3, 1999 · N72062 · Substantial damageNTSB SEA00TA013Accident · Serious injuriesFinal reportHiller UH-12E · Stites, IDInadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…Nov 2, 1999 · N5388V · Substantial damageNTSB SEA00FA014Accident · 1 fatalField investigationFinal reportEnstrom F28C · Pendleton, ORFailure to maintain clearance from the runway surface while maneuvering at low altitude, and inadequate remedial action after the tail rotor struck the surface.Nov 2, 1999 · N635H · DestroyedNTSB MIA00FA019Accident · 1 fatalField investigationFinal reportCessna 152 · Tamarac, FLthe pilot's failure to maintain airspeed resulting in the airplane stalling and entering a spin to the left at an inadequate altitude and his failure to apply spin recovery emergency procedures prior to the airplane impacting the swamp.Nov 2, 1999 · N924JH · DestroyedNTSB LAX00LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe pilot's misjudged landing flare and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing.Nov 2, 1999 · N98909 · Substantial damageNTSB DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.Nov 2, 1999 · N4285Z · Substantial damageNTSB ANC00IA010Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the flight crew to provide a recommended landing traffic advisory, and the failure of flight service station personnel to provide a flight advisory to the arriving airplane concerning men and equipment operating on the runway. Factors in the…Nov 2, 1999 · N792AS · No damageNTSB NYC00FA023Accident · Serious injuriesField investigationFinal reportCessna T303 · Binghampton, NYThe pilot's improper in-flight decision to descend below the decision height without the runway environment in sight, and his failure to execute a missed approach. A factor in the accident was the failed crankshaft.Nov 1, 1999 · N511AR · Substantial damageNTSB IAD00FA003Accident · 1 fatalField investigationFinal reportCoughlin LONG-EZ · Remington, VAthe pilot's failure to maintain adequate altitude/clearance from the trees while maneuvering at low altitude.Nov 1, 1999 · N743TC · DestroyedNTSB FTW00LA023Accident · No injuriesLimited investigationFinal reportCessna 172B · Beaumont, TXFuel exhaustion as a result of the flight instructor's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Nov 1, 1999 · N7833X · Substantial damageNTSB CHI00FA020Accident · 2 fatalField investigationFinal reportBell 206B · Cottage Grove, MNUndetermined.Nov 1, 1999 · N565KS · DestroyedNTSB SEA00FA012Accident · 4 fatalField investigationFinal reportCessna U206F · Challis, IDAircraft control was not maintained. The pilot's improper decision to abort the landing and flight into a box canyon were factors.Oct 31, 1999 · N902CT · Substantial damageNTSB MIA00FA017Accident · 4 fatalField investigationFinal reportCessna T310R · Atlantic Ocean (Atlantic Ocean)the pilot's failure to maintain control of the airplane, which resulted in impact with rough water. A factor in this accident was a dark night, which resulted in no visual cues.Oct 31, 1999 · N4XZ · DestroyedNTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.Oct 31, 1999 · N9063A · Substantial damageNTSB DCA00MA006Accident · 217 fatalClass 1 · MajorFinal reportBoeing 767-366-ER · Atlantic Ocean (Atlantic Ocean)The National Transportation Safety Board determines that the probable cause of the EgyptAir flight 990 accident is the airplane's departure from normal cruise flight and subsequent impact with the Atlantic Ocean as a result of the relief first officer's…Oct 31, 1999 · SUGAP · DestroyedNTSB CHI00LA019Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Benton, KSthe pilot's failure to maintain aircraft control, and the physiological impairment of the pilot due to a brain anomaly. The pilots improper decision to operate the airplane with a known medical deficiency, and the ditch were contributing factors.Oct 31, 1999 · N759NT · Substantial damageNTSB NYC00LA022Accident · 1 fatalLimited investigationFinal reportGodbout Exec 162F · Milan, NHThe pilot's failure to maintain proper rotor rpm while maneuvering, which resulted in main rotor blade flapping, and its subsequent impact with the tail boom. A factor was the pilot's lack of experience in maneuvering flight.Oct 30, 1999 · N228CH · DestroyedNTSB LAX00LA028Accident · No injuriesLimited investigationFinal reportCessna 305A · Torrance, CAThe pilot's loss of directional control during landing rollout due to the failure of the tail wheel control system. A contributing factor was the quartering tailwind condition.Oct 30, 1999 · N5198G · Substantial damageNTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.Oct 30, 1999 · N1162M · Substantial damageNTSB FTW00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bogalusa, LAThe total loss of engine power as a result of water contamination in the fuel system.Oct 30, 1999 · N2654T · Substantial damageNTSB SEA00LA011Accident · No injuriesLimited investigationFinal reportBeech A36TC · Pasco, WAThe pilot's failure to extend the landing gear. Factors include a blocked view of the landing gear light indicating system.Oct 29, 1999 · N3822K · Substantial damageNTSB MIA00LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberry, SCa fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.Oct 29, 1999 · N2648P · Substantial damageNTSB FTW00LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pineville, LAThe student pilot's misjudgment of distance/speed during approach resulting in his failure to attain the proper touchdown point.Oct 29, 1999 · N5301E · Substantial damageNTSB CHI00IA018Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Chicago, ILthe in-flight vibration of the airplane's elevator due to excessive freeplay in the elevator control system. Factors included the corrosion of the elevator PCA reaction link bearings and the elevator hinge bearings, excessive axial and radial wear of the…Oct 29, 1999 · N575UA · No damageNTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.Oct 29, 1999 · N757YQ · Substantial damageNTSB ATL00LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Bay Springs, MSThe pilot's failure to maintain flying speed that resulted in a loss of control and stall. A factor was a stuck exhaust valve.Oct 29, 1999 · N6444F · Substantial damageNTSB SEA00LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Mackay, IDThe pilot's failure to land at the proper touchdown point. Factors include a wind gust, a grass runway, and a drop-off into rough terrain at the end of the runway.Oct 28, 1999 · N12376 · Substantial damageNTSB MIA00LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Cornelia, GAthe pilot misjudged the flare, causing the airplane to porpoise, and subsequently impact with the runwayOct 28, 1999 · N5389Q · Substantial damageNTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.Oct 28, 1999 · N1171F · Substantial damageNTSB LAX00LA027Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Castroville, CAThe pilot's inadequate visual lookout and diverted attention.Oct 28, 1999 · N5374V · Substantial damage