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 LAX90LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAFailure of the student pilot to maintain adequate control of the airplane during the takeoff roll.Apr 2, 1990 · N5169B · Substantial damageNTSB DEN90LA083Accident · No injuriesLimited investigationFinal reportPeterson KIT FOX Model 1 · Highwood, MTA premature lift-off by the pilot, resulting in a stall/mush.Apr 2, 1990 · N87BS · Substantial damageNTSB NYC90FA083Accident · 1 fatalField investigationFinal reportCessna 150F · Lloyd, NYPilot factor in that he was attempting VFR flight in inc conditions and collided with a multipurpose communications tower.Apr 1, 1990 · N7034F · DestroyedNTSB NYC90DNE02Accident · No injuriesFinal reportWalter Hudson Mustang 2 · Westfield, MAAn encounter with wake turbulence from a preceding airplane. A factor related to the accident was the pilot's decision to takeoff close behind the preceeding airplane.Apr 1, 1990 · N29WH · Substantial damageNTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.Apr 1, 1990 · N7363H · Substantial damageNTSB LAX90LA141Accident · No injuriesLimited investigationFinal reportFairchild SA227AC · Panoche, CAThe pilot's poor judgment in attempting a flight while being fatigued due to the lack of sleep which resulted in a loss of control and subsequent overstressing of the airplane.Apr 1, 1990 · N27220 · Substantial damageNTSB LAX90LA132Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Saipan (Pacific Ocean)The partial failure of a rotor system component for undetermined reasons.Apr 1, 1990 · N350AP · DestroyedNTSB DEN90FA085Accident · 2 fatalField investigationFinal reportCessna 421-C · Boulder, COA loss of airplane control as a result control interference by the passenger following a struggle between the pilot and the passenger.Apr 1, 1990 · N2655V · DestroyedNTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.Apr 1, 1990 · N2521C · Substantial damageNTSB ATL90LA090Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Jonesboro, GALoss of engine power because of carburetor icing conditions. A factor in the accident was the pilot's improper use of carburetor heat.Apr 1, 1990 · N37BH · Substantial damageNTSB ANC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot failed to maintain proper obstacle clearance altitude during his final approach.Apr 1, 1990 · N6981B · Substantial damageNTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.Mar 31, 1990 · N663K · Substantial damageNTSB MIA90LA099Accident · No injuriesLimited investigationFinal reportCessna P210N · Natchez, MSThe late extension of the landing gear by the pilot.Mar 31, 1990 · N4738A · Substantial damageNTSB MIA90LA098Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Marathon, FLFailure of the pilot to maintain directional control during takeoff, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the pilot's excessive compensation for the wind condition, and his lack of experience in…Mar 31, 1990 · N89B · Substantial damageNTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.Mar 31, 1990 · N3837J · Substantial damageNTSB LAX90DUM01Accident · 1 fatalFinal reportFreeman H Easton Falcon XP · Glamis, CAThe pilots loss of control while attempting to return to the airstrip after experiencing a partial loss of engine power.Mar 31, 1990 · N542AA · DestroyedNTSB FTW90LA089Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Durant, OKPilot's failure to maintain adequate airspeed (vso) and subsequent stall of the aircraft at an altitude from which recovery was not possible. A factor in the accident was the pilot's improper procedures for the landing approach.Mar 31, 1990 · N7174R · Substantial damageNTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…Mar 31, 1990 · N94496 · Substantial damageNTSB ANC90LA050Accident · No injuriesLimited investigationFinal reportMaule M-4 · Anchorage, AKThe pilot's improper compensation for wind conditions and failure to maintain directional control. The unfavorable (variable) wind and snow covered terrain were related factors.Mar 31, 1990 · N4619T · Substantial damageNTSB ANC90LA049Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kayak Island, AKThe pilot's failure to use a suitable area to taxi for takeoff. The hidden obstruction (log) was a related factor.Mar 31, 1990 · N5061G · Substantial damageNTSB MKC90LA077Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Minneapolis, MNFailure of the pilot to maintain directional control of the aircraft during the landing. The failed (flat) right main tire was a related factor.Mar 30, 1990 · N12KD · Substantial damageNTSB MIA90LA097Accident · No injuriesLimited investigationFinal reportCessna 150L · Vieques, PRFailure of packing around the carburetor accelerator pump, which had jammed throttle movement and would not allow an increase in engine RPM above idle.Mar 30, 1990 · N19599 · Substantial damageNTSB LAX90LA131Accident · No injuriesLimited investigationFinal reportCessna 172M · Groveland, CAThe pilot improperly used the flight controls during the landing roll-out.Mar 30, 1990 · N13685 · Substantial damageNTSB LAX90FA128Accident · 2 fatalField investigationFinal reportCessna P210N · La Verne, CAThe pilot's improper use of powerolant controls which resulted in an excessive rich mixture and power loss. In addition, the pilot failed to maintain adequate airspeed during the forced landing.Mar 30, 1990 · N732CG · DestroyedNTSB CHI90FA105Accident · 1 fatalField investigationFinal reportCessna 152 · Oberlin, OHImproper use of carburetor heat by the dual student, carburetor ice, inadequate supervision to correct the situation by the instructor pilot (CFI), and failure of the CFI to maintain adequate airspeed, which resulted in a stall. Carburetor icing condition was…Mar 30, 1990 · N4671M · DestroyedNTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.Mar 30, 1990 · N7061V · Substantial damageNTSB LAX90DVG03Accident · Serious injuriesFinal reportSmyth Sidewinder Smyth · Georgetown, CAThe failure of the pilot to abort his landing and execute a go-around.Mar 29, 1990 · N23D · Substantial damageNTSB FTW90GA088Accident · 1 fatalFinal reportCessna 337G · Notrees, TXThe pilot's decision to continue VFR flight into known IMC.Mar 29, 1990 · N1886M · DestroyedNTSB ATL90FA093Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Ellijay, GAThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions.Mar 29, 1990 · N55864 · DestroyedNTSB ANC90FA047Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Chevak, AKImproper flare by the pilot (PIC) during the landing/flare. The weather condition with fog was a related factor.Mar 29, 1990 · N200EH · Substantial damageNTSB ANC90FA046Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKCarburetor ice due to the pilot's improper use of the carburetor heat. Factors related to the accident were: carburetor icing conditions, unfavorable wind, and the snow covered terrain.Mar 29, 1990 · N61272 · Substantial damageNTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.Mar 28, 1990 · N83681 · Substantial damageNTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.Mar 28, 1990 · N3630U · Substantial damageNTSB FTW90LA087Accident · Serious injuriesLimited investigationFinal reportBeech 100 · Uvalde, TXImproper IFR procedure by the pilot by not maintaining the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: darkness, low ceiling, fog, and rain.Mar 28, 1990 · N696JB · DestroyedNTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.Mar 28, 1990 · N7134K · Substantial damageNTSB DEN90LA081Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Grand Junction, COThe pilot's failure to correct a swerve during landing roll.Mar 28, 1990 · N426DB · Substantial damageNTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.Mar 27, 1990 · N5524J · Substantial damageNTSB ANC90LA044Accident · No injuriesLimited investigationFinal reportCessna 180J · Lake Nikabuno, AKThe pilot's selection of unsuitable terrain for takeoff.Mar 27, 1990 · N52104 · Substantial damageNTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.Mar 26, 1990 · N2254J · Substantial damageNTSB MKC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Hyannis, NEFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and a subsequent nose over. Factors related to the accident were: the pilot's lack of experience in this aircraft, and the soft terrain.Mar 26, 1990 · N6406G · Substantial damageNTSB LAX90LA126Accident · No injuriesLimited investigationFinal reportCessna 180H · San Carlos, CAThe pilot's failure to maintain directional control of the aircraft during the landing.Mar 26, 1990 · N2790X · Substantial damageNTSB DEN90LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Price, UTThe pilot's inadequate conpensation for the gusty wind conditions, which were a factor.Mar 26, 1990 · N4540X · Substantial damageNTSB ATL90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Buford, GAMar 26, 1990 · N5189K · Substantial damageNTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…Mar 25, 1990 · N4130V · DestroyedNTSB NYC90LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer S2-33A · Brookhaven, NYCause of the accident was a hard landing after the pilot stalled the glider while turning onto final approach.Mar 25, 1990 · N2055T · Minor damageNTSB NYC90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Limington, MEFuel starvation, due to carburetor contamination, which resulted in a forced landing in unsuitable terrain.Mar 25, 1990 · N1895Q · DestroyedNTSB MIA90WA095Accident · No injuriesForeign investigationBeech H-18 · Nassau, BahamasMar 25, 1990 · N7952K · Substantial damageNTSB MIA90LA096Accident · No injuriesLimited investigationFinal reportBell 47D1 · Rockledge, FLFailure of a connecting rod.Mar 25, 1990 · N10326 · Substantial damageNTSB LAX90LA124Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sandy Valley, NVThe pilot's poor flight planning and poor inflight decisions resulting in becoming lost and exhausting fuel before landing.Mar 25, 1990 · N6181B · Substantial damageNTSB LAX90DUK01Accident · Serious injuriesFinal reportKolb Twinstar · Halfmoon Bay, CAFailure of the pilot to maintain adequate airspeed and altitude.Mar 25, 1990 · N287PH · Substantial damage