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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX90FA002Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201T · Palm Springs, CAImproper in-flight planning/decision by the pilot, and his failure to follow wake turbulence avoidance procedures, which resulted in a vortex turbulence encounter. A factor related to the accident was: the pilot's failure to assure the aircraft was loaded…NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB NYC90DNA01Accident · 1 fatalFinal reportSmeesters RV-4 · North Andover, MAThe pilot's inadequate preflight inspection, and his failure to maintain aircraft control during the resultant forced landing.NTSB LAX90LA003Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Penn Valley, CAFailure of the pilot to maintain directional control during the landing roll-out, which resulted in an inadvertent ground swerve. Uneven terrain beside the runway was a factor.NTSB FTW90LA004Accident · No injuriesLimited investigationFinal reportCessna A152 · Mount Pleasant, TXThe pilot failed to compensate for the cross wind during the takeoff initial climb. This led to a loss of directional control and subsequent collision with the windsock standard.NTSB CHI90LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.NTSB ANC90LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKFailure of the right main gear.NTSB NYC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Falls, PAThe right fuel vent became clogged allowing the left fuel tank to become exhausted. In addition, the pilot failed to adequately monitor the fuel supply in each tank.NTSB MIA90WA003Accident · Minor injuriesForeign investigationPiper PA-23-250 · Nevis Island, WNNTSB MIA90LA002Accident · No injuriesLimited investigationFinal reportCessna A188B · Wauchula, FLFuel starvation, improper planning/decision by the pilot, and his failure to attained the emergency procedure. Factors related to the accident were: the low fuel level, and improper planning/decision by the pilot.NTSB FTW90LA003Accident · No injuriesLimited investigationFinal reportAerospatiale 350D · New Iberia, LAThe second pilot's (under instruction) misjudgement of aircraft attitude during the level off phase of the autorotationNTSB FTW90DPJ01Accident · Minor injuriesFinal reportZimmerman Moni Motorglider · Oklahoma City, OKPower loss due to the deteriorated muffler baffle which was not discovered in the recent annual inspection. A factor was the pilot's failure to properly analyze and correct for the headwind.NTSB CHI90LA002Accident · No injuriesLimited investigationFinal reportCessna T182 · Sodus, MIThe pilot-in-command's failure to maintain a proper angle of climb, resulting in a stall.NTSB MKC90LA004Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Gainesville, MOThe pilot's failure to compensate for wind conditions and to maintain runway alignment during the landing approach. Contributing to the accident was the turbulent conditions.NTSB LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.NTSB FTW90LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Edmond, OKInadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).NTSB MIA90LA001Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Belle Glade, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB LAX90LA001Accident · No injuriesLimited investigationFinal reportCessna 501 · Sedona, AZImproper in-flight planning/decision by the pilot which resulted in his inability to flare the aircraft and/or recover from a bounced landing. Contributing factors were: crosswind, gusts, turbulence, downdraft, and the pilot's inadequate compensation for wind…NTSB FTW90FA002Accident · 2 fatalField investigationFinal reportCessna 550 · Hurdle Mills, NCImpairment of the pilot-in-command (PIC) due to drugs/medication, chemotherapy and fatigue; failure of the PIC to assure that the IFR (instrument) apch procedure was followed; and his failure to maintain the minimum descent altitude (mda). Inadequate…NTSB DEN90T#A01Accident · No injuriesClass 3Final reportMBB BO-105S · Mercury, NVNTSB DEN90FA002Accident · 1 fatalField investigationFinal reportCessna 182A · Nixon, NVContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Inadequate preflight preflight planning/preparation by the pilot, and the…NTSB ATL90LA003Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Albemarle, NCThe pilot's failure to maintain directional control of the airplane.NTSB ANC90LA001Accident · No injuriesLimited investigationFinal reportCessna 208 · King Salmon, AKImproper planning/decision by the pilot. Contributing factors were: the surrounding terrain, unfavorable wind, downdraft, the pilot's lack of familiarity with the geographical area, and his self induced pressure.NTSB SEA90LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Las Vegas, NVThe pilot misjudged his altitude and distance to the runway, while on final approach, and failed to attain the proper touchdown point or flare the aircraft during the landing. Darkness was a related factor.NTSB SEA90FA002Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Cougar, WAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.NTSB NYC90LA003Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennington, VTFailure of the student pilot to maintain directional control during landing. Contributing factor(s) was: the crosswind.NTSB NYC90LA002Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Berlin, NYLoss of engine power for an undetermined reason.NTSB NYC90LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bingham, METhe pilot's inadequate preflight planning to assure that the airplane was capable of outclimbing the surrounding terrain under the existing wind and airplane weight conditions, resulting in an intentional stall into the terrain. Contributing factor(s) was:…NTSB MKC90LA003Accident · No injuriesLimited investigationFinal reportStits-Itrich SA6B · Swan, IAThe pilot's failure to adequately compensate for the gusty crosswind conditions which contributed to the accident.NTSB MKC90LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Mountain View, MOLoss of engine power for undetermined reasons. Premature retraction of the landing gear by the pilot was a contributing factor.NTSB MKC90LA001Accident · No injuriesLimited investigationFinal reportAlon Aircoupe · Greers Ferry, ARThe pilot's misjudgement of performance data which resulted in the inability to gain sufficient airspeed for takeoff.NTSB FTW90LA001Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Sulphur, LAThe failure of the landing gear to completely retract which resulted in the inability to gain sufficient airspeed to perform the climbing maneuver.NTSB CHI90LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Manistique, MIA delayed by the pilot in going around and his failure to obtain adequate airspeed before fully retracting the flaps, which allowed the aircraft to mush. The contributing factors were: the pilot's failure to attain the proper touchdown point during the…NTSB ATL90LA002Accident · No injuriesLimited investigationFinal reportBeech V35B · Colquitt, GAThe pilot's failure to obtain current enroute weather information for his destination resulting in his flying VMC into IMC conditions which resulted in his collision with powerlines while making a precautionary landing on a road.NTSB ATL90FA001Accident · 2 fatalField investigationFinal reportBeech C90 · Chamblee, GAMalfunction of one or more flight instruments for an undetermined reason, failue of the pilot to maintain control of the aircraft with partial panel instruments after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft.…NTSB ANC90LA002Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kwethluk, AKThe pilot misjudged his altitude and distance from the runway drg the approach, which resulted in a premature touchdown and failure of the right main landing gear, when it hit the runway lip. The sunglare and lack of visual cues (visual perception) were…NTSB ANC89LA180Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork, AKImproper planning/decision by the pilot.NTSB ANC89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kiana Creek, AKImproper planning/decision by the pilot, and the premature lift-off. Factors related to the accident were: the unfavorable wind condition and the pilot's self-induced pressure.NTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…NTSB SEA89FA182Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Bridal Veil, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the adverse weather conditions, the pilot's lack of instrument experience,…NTSB NYC89FA221Accident · 1 fatalField investigationFinal reportAeronca 65TL · Beaver Falls, PAThe failure of the left wing, rear upper strut attachment. The failure was caused by not installing the retaining bolt and nut.NTSB NYC89DNE03Accident · No injuriesFinal reportHancock MINI-MAX II · Chester, CTThe pilot's failure to attain adequate airspeed. A contributing factor was the pilot's lack of flight time in the airplane.NTSB MKC89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · North Omaha, NEThe pilot's selection of unsuitable terrain on which to make a simulated forced landing.NTSB MKC89FA202Accident · No injuriesField investigationFinal reportFokker F27 · Bemidji, MNThe pilot's failure to maintain a proper descent rate and compensate for the downdraft encountered while on short final approach.NTSB MKC89FA201Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · St. Charles, MNThe pilot's failure to maintain a positive rate of climb during a night takeoff. Contributing factor(s) was: an out-of-c.g airplane, takeoff with only one magneto operating; and the limited vision of the pilot.NTSB LAX89LA332Accident · No injuriesLimited investigationFinal reportCessna 182 · Eureka, CAImproper flare by the student, and a delay in remedial action by the instructor (CFI).NTSB LAX89FA334Accident · 2 fatalField investigationFinal reportCessna 152 · Lancaster, CAThe pilot's decision to enter into IMC while flying under VFR. Factors contributing to accident were: low ceilings, poor planning and decisions, failure to obtain a preflight briefing and not performing a weather evaluation.NTSB LAX89DUM04Accident · No injuriesFinal reportBeech D175 · El Cajon, CAInadequate visual lookout by the pilot of the other aircraft (N9645H).NTSB DEN89LA226Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Hudson, COPartial loss of engine power for an unknown reason. A factor related to the accident was: the alfalfa crop.