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 MIA90LA122Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Daytona Beach, FLThe failure of the pilot of the tailwheel equipped airplane to maintain a visual lookout while taxiing.May 15, 1990 · N50072 · 2 aircraft · Minor damageNTSB LAX90LA175Accident · No injuriesLimited investigationFinal reportPiper PA23-160 · Flagstaff, AZThe failure of the pilot to maintain directional control and to feather the propeller. A factor was erratic power from the left engine due to the jamming of the fuel selector valve in an intermediate position.May 15, 1990 · N4232P · Substantial damageNTSB LAX90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · California City, CAThe pilot's improper landing flare. A factor related to accident was the gusty wind condition.May 15, 1990 · N7406A · Substantial damageNTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.May 14, 1990 · N48SW · Substantial damageNTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.May 14, 1990 · N80104 · Substantial damageNTSB MKC90LA117Accident · Serious injuriesLimited investigationFinal reportBell 47G · Wynne, ARLanding gear skid entangled with a fuel hose. A factor was the pilot's inadequate preflight inspection.May 14, 1990 · N41SD · Substantial damageNTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.May 14, 1990 · N511B · Substantial damageNTSB MIA90WA121Accident · No injuriesForeign investigationBell 222-UT · Lavega, Dominican RepublicMay 14, 1990 · HI462 · Substantial damageNTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.May 14, 1990 · N90778 · Substantial damageNTSB ANC90LA068Accident · No injuriesLimited investigationFinal reportArtic Interstate S1B1 · Talkeetna, AKFuel contamination which precluded the engine from developing the necessary power to clear the mountain ridge.May 14, 1990 · N73AR · Substantial damageNTSB SEA90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Wenatchee, WAThe pilot's failure to maintain directional control during landing.May 13, 1990 · N4527H · Substantial damageNTSB NYC90FA106Accident · 1 fatalField investigationFinal reportCessna 150H · Shirleysburg, PAPilot incapacitation due to a heart attack.May 13, 1990 · N7142S · DestroyedNTSB MIA90LA120Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Marathon, FLFailure of the input drive gear of the tail rotor gear box for undetermined reasons because the drive gear was not recovered from the ocean.May 13, 1990 · N9056 · Substantial damageNTSB LAX90FA170Accident · 1 fatalField investigationFinal reportBell 206B · Carmel Valley, CAThe pilot's inadequate visual lookout and improper climb.May 13, 1990 · N75SH · DestroyedNTSB FTW90DRD08Accident · No injuriesFinal reportSchweizer G-164B · Basile, LAThe pilot's inadequate evaluation of the weather information. A related factor to the accident was the tailwind.May 13, 1990 · N6733Q · DestroyedNTSB BFO90LA042Accident · No injuriesLimited investigationFinal reportBell 47D · Baltimore, MDThe pilot applied excessive cyclic control, causing the main rotor to flex and severe the tail cone.May 13, 1990 · N4229A · Substantial damageNTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).May 12, 1990 · N7SF · DestroyedNTSB NYC90DHJ01Accident · 1 fatalFinal reportToussaint/Quad City Challenger II · East Moriches, NYFailure of the unlicensed pilot to maintain airspeed on final approach, which resulted in a stall and collision with the ground. Factors related to the accident were: the pilot's lack of flight training, experience, and qualification.May 12, 1990 · UNREG · DestroyedNTSB LAX90LA173Accident · No injuriesLimited investigationFinal reportBeech N35 · Los Banos, CAThe pilot's failure to maintain directional control of the aircraft during the takeoff roll.May 12, 1990 · N75BV · Substantial damageNTSB LAX90LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mesa, AZThe pilot-in-command's failure to maintain safe airspeed and inadvertent stall. Contributing to the accident was the pilot's misjudging fuel supply.May 12, 1990 · N6431W · DestroyedNTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.May 12, 1990 · N6382C · Substantial damageNTSB ANC90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Goose Bay, AKLoss of control by the student pilot by prematurely attempting to maneuver the airplane.May 12, 1990 · N7591P · Substantial damageNTSB NYC90FA104Accident · No injuriesField investigationFinal reportShort Brothers SD3-60-200 · Jamaica, NYPilot factor in that the pilot taxied into a hold position that was too close to a departing B-747, which resulted in the a/c being blown into a blast fence. Contributing was the lack of available information from the aircraft manufacturer which would have…May 11, 1990 · N381MQ · Substantial damageNTSB MIA90TL#04Accident · Minor injuriesClass 3Final reportHughes TH-55 · Isle Of Capri, FLMay 11, 1990 · N9048D · DestroyedNTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.May 11, 1990 · N3749E · Substantial damageNTSB LAX90LA171Accident · No injuriesLimited investigationFinal reportHughes 369E · Firebaugh, CAFailure by company maintenance to perform a mandatory compressor section inspection that resulted in the undetected erosion of the compressor vanes and engine failure. Contributing to the accident was the failure of the pilot to maintain adequate main rotor…May 11, 1990 · N5217N · Substantial damageNTSB LAX90LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · El Monte, CAThe failure of the pilot in command to adequately configure the aircraft for the takeoff portion of a touch and go.May 11, 1990 · N505GM · Substantial damageNTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.May 11, 1990 · N4352C · Substantial damageNTSB BFO90LA043Accident · Serious injuriesLimited investigationFinal reportBoeing B-737 · Washington, DCThe aircraft encountered turbulence, resulting in injury to a flight attendant.May 11, 1990 · N990UA · No damageNTSB ATL90LA112Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Chamblee, GAFailure of the student (rated) pilot to maintain control of the helicopter, and insufficient supervision by the instructor pilot (CFI).May 11, 1990 · N2579W · Substantial damageNTSB MIA90FA118Accident · 2 fatalField investigationFinal reportCessna 172K · Mayaguez, PRThe pilot's failue to conduct proper preflight preparations, resulting in a takeoff at 175 pounds over maximum allowable gross weight, with full flaps extended, and on the improper runway for wind conditions which resulted in the airplane being unable to…May 10, 1990 · N7268G · DestroyedNTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.May 10, 1990 · N62672 · Substantial damageNTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.May 10, 1990 · N7628D · Substantial damageNTSB BFO90FA045Accident · 6 fatalField investigationFinal reportCessna 210N · Shady Grove Cor, VAVFR flight by the non-instument rated pilot into instrument meteorological conditions (IMC), his loss of aircraft control, due to spatial disorientation, and his exceeding the design stress limits of the aircraft, while recovering from an uncontrolled…May 10, 1990 · N6481N · DestroyedNTSB MIA90FA117Accident · Minor injuriesField investigationFinal reportHughes 269C · Fort Pierce, FLImproper touchdown during the autorotation by the dual student (ATP), his failure to maintain runway alignment, inadequate supervision by the CFI, and inadequate crew coordination. A factor related to the accident was the obstruction (taxiway light).May 9, 1990 · N58275 · DestroyedNTSB LAX90LA168Accident · No injuriesLimited investigationFinal reportRobinson R22 · Irvine, CAThe cfi's failure to maintain rotor RPM during the practice autorotation.May 9, 1990 · N9070N · Substantial damageNTSB ATL90FA111Accident · 1 fatalField investigationFinal reportCessna P206 · Liberty, NCA loss of engine power due to improper repairs to, and inadequate inspection of, the induction air box. The night light condition was a contributing factor.May 9, 1990 · N220P · Substantial damageNTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.May 8, 1990 · N18024 · Substantial damageNTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.May 8, 1990 · N9071Z · Substantial damageNTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.May 8, 1990 · N6202Q · Substantial damageNTSB NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.May 8, 1990 · N2369N · DestroyedNTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.May 8, 1990 · N5368 · Substantial damageNTSB FTW90LA107Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaplan, LARestricted movement of the right skid assembly causing the lateral center of gravity to be exceeded during the attempted take off.May 8, 1990 · N2187P · Substantial damageNTSB FTW90DPA03Accident · No injuriesFinal reportBell-Moore 47G-2A · Sivell Bend, TXClearance was not maintained by the pilot-in-command.May 8, 1990 · N25126 · Substantial damageNTSB DEN90LA107Accident · Minor injuriesLimited investigationFinal reportBeech B-55 · Watkins, COExecuting of a simulated single engine approach in wind conditions that exceeded the demonstrated crosswind capability of the airplane with both engines operating.May 8, 1990 · N113EW · Substantial damageNTSB DEN90DTK01Accident · 1 fatalFinal reportPiper PA-36-375 · Woonsocket, SDFailure of the pilot of N3634E to follow the briefed plan of operation, and failure of both pilots to see-and-avoid each other (inadequate visual lookout).May 8, 1990 · N3634E · 2 aircraft · DestroyedNTSB CHI90LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Anderson, INThe pilot failed to adequately compensate for the wind conditions. The gusty crosswind was a factor.May 8, 1990 · N3081W · Substantial damageNTSB ATL90FA110Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Hilton Head, SCThe pilot's mismanagement of the fuel system through inadvertant selection of the 'off' position of the fuel selector valve handle.May 8, 1990 · N9538J · Substantial damageNTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.May 7, 1990 · N1011A · Substantial damageNTSB SEA90LA075Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, WAA malfunctioning fuel injection system and the pilot's attempted operation above certificated maximum gross weight with a known deficiency in this equipment.May 7, 1990 · N57514 · Substantial damage