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 NYC90LA066Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe pilot of N349MA failed to see and avoid another airplane taxiing in the same direction.Feb 9, 1990 · N349MA · 2 aircraft · Substantial damageNTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.Feb 9, 1990 · N7359G · Substantial damageNTSB DEN90FA055Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rapid City, SDFailure of the pilot to maintain adequate airspeed (VMC), which resulted in a loss of aircraft control. A factor related to the accident was: fatigue failure of a coupling shaft in the #1 engine, which resulted in loss of power in that engine.Feb 9, 1990 · N64MD · Substantial damageNTSB BFO90FA024Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Norton, VAPilot's failure to maintain adequate clearance over mountainous terrain when continuing to fly into deteriorating weather conditions. Contributing to the accident was the pilot's lack of instrument experience, low ceilings, fog, and mountainous terrain.Feb 9, 1990 · N40793 · DestroyedNTSB NYC90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Duanesburg, NYThe failure of the flight instructor to adequately monitor the actions of the student pilot and apply corrective action in a timely manner.Feb 8, 1990 · N4768X · Substantial damageNTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.Feb 8, 1990 · N9342T · Substantial damageNTSB MIA90WA068Accident · 5 fatalForeign investigationMooney M20F · San Andros, BahamasFeb 7, 1990 · N9370M · DestroyedNTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.Feb 7, 1990 · N32744 · 2 aircraft · Substantial damageNTSB DEN90FA053Accident · 6 fatalField investigationFinal reportBell 205A-1 · Wrangell, AKThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: company induced pressure to make the flight, the pilot's…Feb 7, 1990 · CGNMJ · DestroyedNTSB LAX90FA084Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Bakersfield, CAThe pilot's failure to activate the pitot heat before flying at and above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…Feb 6, 1990 · N8888M · DestroyedNTSB LAX90FA083Accident · 1 fatalField investigationFinal reportCessna 152 · Phoenix, AZDesign stress limits exceeded.Feb 6, 1990 · N6471L · Substantial damageNTSB LAX90FA082Accident · 3 fatalField investigationFinal reportBeech 95-55 · Chico, CAThe failure of the pilots of N790T and N721L to see and avoid each other. Factors which contributed to the accident were: the pilot of the C-182P, N790T, was disoriented and improperly entered the traffic pattern due to recent marijuana use; the pilot of the…Feb 6, 1990 · N721L · 2 aircraft · DestroyedNTSB DEN90LA051Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Burlington, COThe failure of the dual student to correct a ground loop swerve during takeoff ground run. Inadequate supervision by the CFI was a factor in the accident.Feb 6, 1990 · N11641 · Substantial damageNTSB CHI90LA076Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · South Webster, OHAn engine failure. Soft terrain in the forced landing area is a factor.Feb 6, 1990 · N5236L · Substantial damageNTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.Feb 6, 1990 · N4338U · DestroyedNTSB SEA90FA045Accident · 1 fatalField investigationFinal reportCessna 402B · Baker, ORPilot displayed poor inflight planning by selecting to fly into known adverse weather conditions. The pilot did not maintain an adequate visual lookout when operating in snow shower conditions and collided into the terrain.Feb 5, 1990 · N50GP · DestroyedNTSB LAX90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mammoth Lakes, CAThe pilot's inadequate removal of ice from the fuselage, wings, and horizontal stabilizer prior to takeoff.Feb 5, 1990 · N8620N · Substantial damageNTSB FTW90LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Roanoke, TXThe partial power loss due to a failed exhaust valve and the failure of the pilot to maintain adequate speed during the precautionary landing approach.Feb 5, 1990 · N33052 · Substantial damageNTSB SEA90LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Winthrop, WAWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. Darkness and the obstructions in the emergency landing area were related factors.Feb 4, 1990 · N49573 · Substantial damageNTSB SEA90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boring, ORCarburetor icing, and the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing conditions and the soft/uneven terrain in the emergency landing area.Feb 4, 1990 · N8898C · Substantial damageNTSB FTW90FA063Accident · 1 fatalField investigationFinal reportCessna 172M · Tomball, TXFailure of the pilot in Cessna 150, N714RS, to comply with the air traffic control clearance, and failure of both pilots to maintain adequate visual lookout to see-and-avoid each other. Factors related to the accident were: physical impairment of the pilot in…Feb 4, 1990 · N128S · 2 aircraft · DestroyedNTSB MIA90LA066Accident · No injuriesLimited investigationFinal reportCessna 172A · Pahokee, FLLoss of engine power for am undetermined reason.Feb 3, 1990 · N6812X · Substantial damageNTSB MIA90LA065Accident · Serious injuriesLimited investigationFinal reportMooney M-20K-231 · Winter Haven, FLThe pilot in command failed to properly pre-flight the airplane and assure that an adequate fuel supply was onboard to complete the intended flight. This resulted in an engine failure due to fuel exhaustion.Feb 3, 1990 · N1173E · Substantial damageNTSB MIA90FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Sebastian, FLFailure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…Feb 3, 1990 · N473FT · 2 aircraft · DestroyedNTSB DEN90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Provo, UTImproper installation by maintenance personnel and fatigue failure and leakage of the left intermediate exhaust pipe, which resulted in an in-flight fire in the engine compartment. Contributing factors were: inadequate service bulletin provided by the…Feb 3, 1990 · N21492 · Substantial damageNTSB DEN90LA050Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts · Las Vegas, NVThe pilot-in-command's failure to maintain directional control after a partial failure of the normal brake system.Feb 3, 1990 · N25CH · Substantial damageNTSB DEN90LA048Accident · No injuriesLimited investigationFinal reportCameron N105 · Littleton, COInadequate compensation for the wind conditions by the pilot in command.Feb 3, 1990 · N29675 · Substantial damageNTSB CHI90TF#01Accident · No injuriesClass 3Final reportNorth American NA-265-40 · Detroit, MIFeb 3, 1990 · N50CD · Substantial damageNTSB SEA90FA039Accident · 1 fatalField investigationFinal reportPiper PA28-180 · Castle Rock, WAThe pilot lost control of the airplane which entered a stall/spin that the pilot did not recover from.Feb 2, 1990 · N8859J · DestroyedNTSB MIA90FA064Accident · 2 fatalField investigationFinal reportBeech 58 · Pensacola, FLIn flight loss of control for undetermined reasons.Feb 2, 1990 · N431BR · DestroyedNTSB ATL90FA055Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Cherokee, ALCarburetor ice due to the pilot's improper use of carburetor heat, and failure of the pilot to maintain control of the airplane after the engine lost power. The weather (carburetor icing) condition was a related factor.Feb 2, 1990 · N5755L · DestroyedNTSB NYC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · E. Haddam, CTThe pilot failed to adequately compensate for wind conditions.Feb 1, 1990 · N1335T · Substantial damageNTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.Feb 1, 1990 · N83253 · DestroyedNTSB FTW90LA061Accident · No injuriesLimited investigationFinal reportRobinson R22 · San Angelo, TXInadequate preflight by the pilot by not identifying and removing the tie-down.Feb 1, 1990 · N25318 · Substantial damageNTSB FTW90FA062Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Coalgate, OKFlight into known adverse weather conditions by the non-instrument rated pilot, and his subsequent spatial disorientation, which resulted in a loss of aircraft control. Factors related to the accident were: inoperative instrument panel lights, dark night,…Feb 1, 1990 · N9235Z · DestroyedNTSB CHI90FA075Accident · 1 fatalField investigationFinal reportBoeing 727 · Indianapolis, INThe tug operator's failure to maintain control of the tug, possibly due to having inadvertently placed or caught his built-up, steel-toe boot under the brake pedal.Feb 1, 1990 · N519FT · Minor damageNTSB SEA90LA037Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Coeur D'Alene, IDThe loss of the flight crew's visual perception, due to an unforeseen whiteout condition. A related factor was the snowbank.Jan 31, 1990 · N56EA · Substantial damageNTSB NYC90LA064Accident · No injuriesLimited investigationFinal reportMooney M20-K · Gibsonia, PAThe collision with rods in the field as the pilot was attempting a forced landing after a complete engine failure.Jan 31, 1990 · N1149G · Substantial damageNTSB NYC90LA062Accident · No injuriesLimited investigationFinal reportCessna 182N · Milford, PAThe loss of directional control by the pilot during a short soft field takeoff on a snow packed runway.Jan 31, 1990 · N8947G · Substantial damageNTSB BFO90MA023Accident · 1 fatalMajor investigationFinal reportHawker Siddeley HS.125-35 · Columbia, MOInadequate preflight by the pilot(s), water contamination of the fuel, low level of deice fluid (methanol) in the deice tank, and subsequent ice blockage of the fuel filters. Darkness was a related factor.Jan 31, 1990 · G0B0B · DestroyedNTSB ATL90LA059Accident · No injuriesLimited investigationFinal reportCessna 425 · Augusta, GAFailure of the pilot to maintain control of the aircraft during the go-around. A factor related to the accident was: the pilot's delay in initiating the go-around.Jan 31, 1990 · N6846D · Substantial damageNTSB ATL90IA060Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Louisville, KYThe disabling of the main landing gear torque link which allowed the truck to rotate freely. The torque link was disabled when excessive vibration was generated by excessive play of the torque link pins in their bushings.Jan 31, 1990 · N8978E · Minor damageNTSB NYC90FA061Accident · 2 fatalField investigationFinal reportCessna 208B · Williston, VTThe failure of the pilot to de-ice the airplane prior to departure, and his decision to make the takeoff at a weight that exceeded both the maximum structural takeoff weight and the reduced takeoff weight allowed for icing conditions resulting in an…Jan 30, 1990 · N4688B · DestroyedNTSB NYC90FA060Accident · 1 fatalField investigationFinal reportCessna 208B · Schuyler Falls, NYLoss of control inflight after the airplane stalled during climbout. The stall resulted from a loss of lift due to a contaminated wing surface. Contributing to the accident was the failure of the pilot to de-ice the aircraft prior to departure.Jan 30, 1990 · N854FE · DestroyedNTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.Jan 30, 1990 · N9172Y · Substantial damageNTSB CHI90LA074Accident · No injuriesLimited investigationFinal reportMBB BK-117A-1 · Janesville, WIThe pilot-in-command failed to ensure that the engine cowling latches were properly secured prior to departing on the maintenance test flight; the cowling came loose during flight, and contacted the main rotor blades before it separated from the helicopter.Jan 30, 1990 · N117M · Substantial damageNTSB CHI90LA073Accident · No injuriesLimited investigationFinal reportBell 222 · Middleville, MIThe pilot's inadequate visual lookout and failure to maintain proper altitude and clearance from the tv tower. The tv tower (guy wire) was a related factor.Jan 30, 1990 · N828WA · Substantial damageNTSB ATL90FA056Accident · Serious injuriesField investigationFinal reportCessna 150F · Weaver, ALThe pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…Jan 30, 1990 · N6871F · Substantial damageNTSB FTW90DRG02Accident · Minor injuriesFinal reportThompson Baker BOB-CAT · New Braunfels, TXThe pilot's failure to maintain flying speed during an emergency descent for a forced landing. A factor was the loss of engine power.Jan 29, 1990 · N60RT · Substantial damageNTSB NYC90LA059Accident · No injuriesLimited investigationFinal reportGlobe Swift Gcib · Pittstown, NJThe pilot failed to abort the takeoff after losing directional control during the takeoff ground run. Factors related to the accident were: crosswind, hidden obstruction in high vegetation, and low time in model.Jan 28, 1990 · N78156 · Substantial damage