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 NYC90DNE01Accident · No injuriesFinal reportNorth American T-28B · New Braintree, MAThe failure of the nose gear, which failed to retract with the main landing gear after takeoff; the gear was observed to be misaligned, and collapsed during the aircraft's touchdown.Oct 28, 1989 · N504GH · Substantial damageNTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.Oct 28, 1989 · N5725X · DestroyedNTSB MIA90LA019Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Zellwood, FLImproper planning/decision by the pilot. The crosswind and ditch were related factors.Oct 28, 1989 · N80528 · Substantial damageNTSB MIA90LA018Accident · Minor injuriesLimited investigationFinal reportBell 47G · West Palm Beach, FLThe pilot's inadequate compensation for wind conditions. Factors related to the accident were: the unfavorable and gusty wind conditions.Oct 28, 1989 · N6359E · Substantial damageNTSB LAX90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Bishop, CAThe pilot's neglect in failure to ensure adequate clearance was available to pass the parked refueling vehicle. The refueling vehicle parking position on an active taxiway was a factor in the accident.Oct 28, 1989 · N7594J · Substantial damageNTSB CHI90LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Ravenna, OHThe pilot's failure to maintain aircraft control and airspeed which resulted in a stall. Factors related to the accident include the pilot overshooting the approach & landing due to misjudging his airspeed & distance, and a delayed go-around.Oct 28, 1989 · N7117U · Substantial damageNTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.Oct 28, 1989 · N2412N · Substantial damageNTSB ATL90FA016Accident · Minor injuriesField investigationFinal reportCessna T210M · Peachtree City, GAThe improper calibration of the fuel quantity gauges by maintenance personnel, which resulted in erroneous fuel quantity indications and led to fuel starvation. Contributing to the accident were the unsuitable terrain conditions that existed at the…Oct 28, 1989 · N8444M · Substantial damageNTSB SEA90LA010Accident · No injuriesLimited investigationFinal reportHughes 369D · Neah Bay, WAFatigue failure of all four attachment studs of the tailrotor gearbox resulting in separation of the gear box, and inadequate maintenance inspection.Oct 27, 1989 · N9163F · Substantial damageNTSB LAX90DUD01Accident · Minor injuriesFinal reportWheeler Acft. Express 100 · W. Los Angeles, CAThe mechanical failure of the engine due to the wearing away of the piston pin plug, connecting rod bearings, and the breakage of the connecting rod at the lower end. Contributing to the severity of the accident was the forced landing into a residential area…Oct 27, 1989 · N200EX · DestroyedNTSB FTW90FA018Accident · 2 fatalField investigationFinal reportCessna TR182 · Crane, TXThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his loss of aircraft control, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument…Oct 27, 1989 · N756WH · DestroyedNTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.Oct 27, 1989 · N33211 · Substantial damageNTSB DEN90IA016Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Rapid City, SDThe inflight failure of the recirculating fan unit and several air duct temperature limiting sensors.Oct 27, 1989 · N344UA · No damageNTSB CHI90DEK02Accident · Minor injuriesFinal reportEickmeier Pitts Special/S1C · Van Buren, OHA total loss of engine power for an undetermined reason.Oct 27, 1989 · N4JE · Substantial damageNTSB ATL90DKJ02Accident · No injuriesFinal reportBell 47G2 · Wettumpka, ALThe pilot's failure to avoid obstacles during aerial application maneuvering.Oct 27, 1989 · N9025 · DestroyedNTSB LAX90LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · Simi Valley, CAStudent pilot's failure to maintain the proper altitude.Oct 26, 1989 · N84817 · Substantial damageNTSB LAX90FA017Accident · 2 fatalField investigationFinal reportBeech F35 · Lake Berryessa, CAInadequate visual lookout by the pilot and his failure to maintain proper altitude. The power lines was a related factor.Oct 26, 1989 · N5034B · DestroyedNTSB FTW90DRG01Accident · Serious injuriesFinal reportFunk, D.D. B85C · San Antonio, TXFailure of the pilot to maintain airspeed, which resulted in a stall. The unfavorable/gusty wind condition was a related factor.Oct 26, 1989 · N77707 · Substantial damageNTSB CHI90FA019Accident · 1 fatalField investigationFinal reportBeech B35 · Clare, MIImproper preflight by the pilot by not assuring that the fuel selector was properly positioned, which resulted in fuel starvation, and the pilot's failure to maintain airspeed, which resulted in a stall/spin.Oct 26, 1989 · N8805A · DestroyedNTSB BFO90FA002Accident · 1 fatalField investigationFinal reportBeech 58P · Nokesville, VAImproper installation of the elevator trim actuators, and subsequent jamming of the elevator trim in a nose down trim position.Oct 26, 1989 · N86MC · DestroyedNTSB ATL90LA015Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Florence, SCThe worn steering system.Oct 26, 1989 · N57470 · Substantial damageNTSB NYC90LA017Accident · Minor injuriesLimited investigationFinal reportCessna T172N · Townsend, MAThe pilot's failure to use carburetor heat during weather conditions favorable to carburetor icing. A contributing factor was the lack of suitable terrain.Oct 25, 1989 · N6309F · Substantial damageNTSB MIA90FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Columbia, MSSuicide. The pilot's emotional state of distress was a related factor.Oct 25, 1989 · N19007 · DestroyedNTSB LAX90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ontario, CAImproper use of the brakes by the pilot of the Piper PA-31.Oct 25, 1989 · N4098A · 2 aircraft · Substantial damageNTSB LAX90LA011Accident · No injuriesLimited investigationFinal reportCessna 150L · Marana, AZFailure of the pilot to properly judge his fuel supply, which resulted in fuel exhaustion.Oct 25, 1989 · N642EZ · Substantial damageNTSB DEN90FA013Accident · 2 fatalField investigationFinal reportCessna T210L · Penasco, NMImproper inflight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were: failure of the pilot to obtain (and/or understand) wind aloft information, his lack of…Oct 25, 1989 · N93110 · DestroyedNTSB ATL90LA014Accident · No injuriesLimited investigationFinal reportCessna 150K · Vine Grove, KYInadequate preflight planning/preparation by the student pilot, which led to fuel exhaustion due to an inadequate supply of fuel. The pilot's failure to attain the proper touchdown point during the landing and the parked airplane were contributing factors.Oct 25, 1989 · N2662Q · Substantial damageNTSB ATL90LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kinston, NCThe pilot's decision to depart for his destination airport with less than required fuel, and his improper use of the communications radio which resulted in his circling the airport and exhausting all fuel.Oct 25, 1989 · N67318 · Substantial damageNTSB MKC90LA018Accident · No injuriesLimited investigationFinal reportPierce MP-2 · Caledonia, MNThe pilots loss of control during recovery from bounced landing.Oct 24, 1989 · N6FP · Substantial damageNTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.Oct 24, 1989 · N36163 · DestroyedNTSB LAX90FA016Accident · 3 fatalField investigationFinal reportCessna 177 · So Lake Tahoe, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions.Oct 24, 1989 · N30228 · DestroyedNTSB FTW90LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thibodaux, LAStudent pilot's failure to obtain or maintain airspeed during an aborted landing, which resulted in an inadvertent stall/mush. His failure to maintain runway alignment and the ditch were related factors.Oct 24, 1989 · N4973B · Substantial damageNTSB FTW90FA015Accident · No injuriesField investigationFinal reportBeech 58 · San Antonio, TXA fuel tank leak, arcing from the exterior lighting system, and failure of company/maintenance personnel to comply with an airworthiness directive (AD).Oct 24, 1989 · N950JP · Substantial damageNTSB DEN90LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe pilot's improper flare and improper recovery from a bounced landing. The wind condition was considered to be a contributing factor.Oct 24, 1989 · N95975 · Substantial damageNTSB ATL90LA012Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Knightdale, NCThe pilot's failure to maintain the proper glide path to the runway resulting in the airplane colliding with trees while making an approach to landing with no electrical power.Oct 24, 1989 · N737QG · Substantial damageNTSB SEA90LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Reno, NVThe inadequate compensation for gusty wind conditions.Oct 23, 1989 · N9925T · Substantial damageNTSB MKC90LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Cherokee Vill, ARThe pilots failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.Oct 23, 1989 · N704SZ · Substantial damageNTSB FTW90LA012Accident · No injuriesLimited investigationFinal reportCessna 170B · New Boston, TXA loss of engine power for undetermined reasons. The dirt bank contacted during the landing is considered to be contributing factor.Oct 23, 1989 · N8188A · Substantial damageNTSB ATL90GA010Accident · Serious injuriesFinal reportHiller UH-12D · Mentor, OHImproper in-flight planning/decision by the pilot. Factors related to the accident were: the pilot's improper compensation for wind conditions and trees.Oct 23, 1989 · N63LC · DestroyedNTSB MKC90LA016Accident · No injuriesLimited investigationFinal reportHughes 369HS · Ogilvie, MNLoss of engine power for an undetermined reason. Factors related to the accident were: the unsuitable terrain conditions in the emergency landing area.Oct 22, 1989 · N3961H · Substantial damageNTSB MKC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charles City, IAThe pilot-in-command's failure to maintain adequate control of the aircraft during the landing phase coupled with the cfi's inadequate supervision during the instructional flight. The cfi's lack of familiarity with the accident aircraft was a contributing…Oct 22, 1989 · N2366N · Substantial damageNTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.Oct 22, 1989 · N288BH · DestroyedNTSB FTW90LA020Accident · No injuriesLimited investigationFinal reportCessna 150H · Mountain Home, TXLack of airspeed for a climb to clear obstacles off the departure end of the runway, resulting in a precautionary landing into unsuitable terrain. The inadequate airspeed was a result of an encounter with deer during the take off and the pilots vertical…Oct 22, 1989 · N22614 · Substantial damageNTSB FTW90LA016Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Friona, TXThe pilot's decision to perform an aerobatic maneuver during initial climb out with inadequate altitude for recovery.Oct 22, 1989 · N7632S · Substantial damageNTSB FTW90LA014Accident · No injuriesLimited investigationFinal reportCessna T-337G-P · Laredo, TXDouble engine failure due to fuel exhaustion. The fuel exhaustion was caused by incorrect inflight fuel consumption calculations and one inaccurate fuel quanity gauge. Contributing to the accident was the dark night restriction to visibility.Oct 22, 1989 · N21GC · Substantial damageNTSB CHI90LA018Accident · No injuriesLimited investigationFinal reportBeech A36 · Lansing, ILPilot's poor judgement in electing to taxi across an unmarked area in dark night conditions, at an airport with known construction in progress and the airport management's failure to assure the initial repairs were sufficient to correct the holes made during…Oct 22, 1989 · N6736L · Substantial damageNTSB CHI90LA017Accident · No injuriesLimited investigationFinal reportDe Havilland DH82A · Mascoutah, ILAn undetermined powerplant problem, which resulted in a severe vibration. The soft/uneven terrain was considered to be a contributing factor.Oct 22, 1989 · N100MH · Substantial damageNTSB CHI90DEP01Accident · Serious injuriesFinal reportWychen Challenger II · Warrens, WIA broken cranskshaft which resulted in the loss of power. A factor related to the accident was: the lack of suitable terrain for a forced landing.Oct 22, 1989 · N91269 · Substantial damageNTSB ATL90LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cumming, GAA lack of fluid in the brake system and an inadequate annual inspection.Oct 22, 1989 · N96804 · Substantial damageNTSB ANC90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKFailure of the pilot to maintain of the aircraft while maneuvering.Oct 22, 1989 · N847DG · Substantial damage