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 LAX97LA119Accident · No injuriesLimited investigationFinal reportCessna 172N · Oakland, CAthe student pilot's failure to completely reduce the throttle after landing, and his failure to maintain proper runway alignment.Mar 10, 1997 · N6375D · Substantial damageNTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.Mar 10, 1997 · N9485B · Substantial damageNTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.Mar 10, 1997 · N65753 · Substantial damageNTSB FTW97IA119Incident · No injuriesIncident investigationFinal reportBoeing 727-2K5 · Dfw Airport, TXfailure of the outer bearing for undetermined reason(s).Mar 10, 1997 · N909PG · Minor damageNTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.Mar 9, 1997 · N4969K · Substantial damageNTSB IAD97LA062Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Woodbine, MDThe pilot misjudged his altitude during approach.Mar 9, 1997 · N2559H · Substantial damageNTSB CHI97LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Two Harbors, MNfailure of the pilot to maintain directional control of the airplane during landing. Factors relating to the accident were: the gusty crosswind condition, and the snowbank.Mar 9, 1997 · N9950Y · Substantial damageNTSB ATL97LA049Accident · No injuriesLimited investigationFinal reportCessna 441 · Madison, MSfailure of the pilot to follow the landing checklist, which resulted in a gear-up landing.Mar 9, 1997 · N423TG · Substantial damageNTSB ANC97LA033Accident · No injuriesLimited investigationFinal reportCessna 337T · Fairbanks, AKa leaking landing gear actuator seal, which resulted in an inability of the landing gear to lock in the down position. Failure of the emergency gear extension handle was a related factor.Mar 9, 1997 · N922EJ · Substantial damageNTSB ANC97LA032Accident · No injuriesLimited investigationFinal reportCessna 170A · Willow, AKThe pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.Mar 8, 1997 · N1364D · Substantial damageNTSB SEA97FA070Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Boise, IDthe accumulation of airframe ice on the aircraft, and the pilot's delayed remedial action after intentionally flying into forecast adverse weather conditions. The adverse weather (icing) conditions were related factors.Mar 7, 1997 · N7583P · DestroyedNTSB DCA97WA033Accident · No injuriesForeign investigationCessna Citation 500 · Medellin, Central African RepublicMar 7, 1997 · HK-3885NTSB DCA97WA032Accident · Serious injuriesForeign investigationBritten-Norman BN2A-26 · Paseo Las Palma, Costa RicaMar 7, 1997 · N851JA · DestroyedNTSB CHI97LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mosinee, WIThe formation of carburetor ice and the instructor pilot's failure to recognize conditions leading to carburetor icing and to take appropriate preventative action. Factors relating to this accident were the late application of carburetor heat, the icing…Mar 7, 1997 · N8259M · Substantial damageNTSB ATL97LA047Accident · Minor injuriesLimited investigationFinal reportConvair 240-27 · Hampton, GAa partial loss of power on one engine for undetermined reason(s), and the pilot's failure to follow aircraft emergency procedures. A factor was inadequate transition/upgrade training.Mar 7, 1997 · N357T · Substantial damageNTSB ANC97FA031Accident · 2 fatalField investigationFinal reportBuesing SX-300 · Sitka, AKthe pilot's failure to properly evaluate the presence of icing conditions, and his failure to comply with procedures to use alternate engine air in icing conditions. Factors relating to the accident were: icing (weather) conditions, the pilot's improper…Mar 7, 1997 · N357SX · DestroyedNTSB NYC97FA057Accident · 2 fatalField investigationFinal reportBeech E-18S · Mabie, WVThe pilot's disregard of the preflight weather briefing for severe weather along his route of flight, and his departure into the known and forecasted severe weather. A factor in the accident was the inadequate FAA oversight of the operator, which fostered an…Mar 6, 1997 · N54BT · DestroyedNTSB MIA97FA095Accident · 3 fatalField investigationFinal reportCessna T210L · Meridianville, ALthe pilot's improper decision to takeoff downwind which resulted in his failure to maintain control of the airplane. The winds were a factor.Mar 6, 1997 · N2142S · DestroyedNTSB IAD97FA052Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 · Cleveland, OHThe pilot in command did not maintain control while utilizing the full auto-land system. Factors to this accident were a contaminated runway, a crosswind, and inadequate guidance provided in the aircraft manual.Mar 6, 1997 · N275AA · Substantial damageNTSB FTW97LA118Accident · No injuriesLimited investigationFinal reportRyan Navion A · Hudson, COA total power loss due to fuel starvation as a result of the pilot's inadequate preflight inspection of the airplane and its fuel system. Factors include: the pilot's failure to refuel the airplane, the improper fuel tank selector position that would not…Mar 6, 1997 · N800PS · Substantial damageNTSB FTW97LA117Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Newkirk, OKThe partial loss of engine power due to failure of the blower (integral supercharger). A factor was the power line over which the pilot had to maneuver during the forced landing which resulted in insufficient airspeed to flare the airplane.Mar 6, 1997 · N527Y · Substantial damageNTSB CHI97LA079Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, MIthe pilot failed to maintain directional control of the aircraft during landing. Factors included the inadequate compensation for the crosswind conditions, the crosswind, and gusts.Mar 6, 1997 · N8782V · Substantial damageNTSB NYC97LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355F · Washington, PAThe malfunction of a cyclic servo which resulted in a cyclic hard over at a hover.Mar 5, 1997 · N101UC · Substantial damageNTSB ATL97LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fernandina Bch, FLinadequate visual lookout by the student pilot, which resulted in a collision with a parked trailer, while his attention was diverted. The proximity of the trailer was a related factor.Mar 5, 1997 · N757HA · Substantial damageNTSB ATL97LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Aikens, SCexcessive wear of the fuel metering unit/shaft, which resulted in a fuel leak and premature exhaustion of the fuel supply.Mar 5, 1997 · N7312V · Substantial damageNTSB MIA97LA096Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Huntsville, ALTotal loss of engine power due to fuel exhaustion for undetermined reasons.Mar 4, 1997 · N3392Y · Substantial damageNTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.Mar 4, 1997 · N4345C · Substantial damageNTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…Mar 4, 1997 · N3257C · Substantial damageNTSB FTW97LA114Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Jamaica Beach, TXThe pilot's encounter with instrument meteorological conditions, and his subsequent loss of aircraft control due to the loss of visual cues to detect his height above the water. Factors were the low ceilings and fog, and the loss of tail rotor effectiveness.Mar 4, 1997 · N5829D · DestroyedNTSB FTW97LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thibodaux, LAThe failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…Mar 4, 1997 · N2654T · Substantial damageNTSB FTW97IA120Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Abilene, TXThe flightcrew's failure to maintain aircraft control. Factors were the tailwind and a partial nosewheel steering failure.Mar 4, 1997 · N373PH · No damageNTSB SEA97FA067Accident · 1 fatalField investigationFinal reportBeech 200 · Salt Lake City, UTThe pilot's failure to maintain adequate airspeed on the ILS approach, resulting in a stall. Factors included: low visibility; the pilot's selection of the improper DME for the approach; his resulting failure to attain the proper descent profile for the…Mar 3, 1997 · N117WM · Substantial damageNTSB MIA97WA092Accident · 6 fatalForeign investigationCessna 402A · Caracas, VenezuelaMar 3, 1997 · YV784 · DestroyedNTSB LAX97LA117Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Alpine, CAA loss of engine power due to fuel starvation caused by an obstruction in the fuel vapor return system. An additional causal finding is the failure of maintenance personnel to properly troubleshoot a discrepancy with the fuel system.Mar 3, 1997 · N5027F · Substantial damageNTSB LAX97LA116Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Morristown, AZfailure of the crankshaft due to improper inspection/overhaul procedures.Mar 3, 1997 · N39W · DestroyedNTSB FTW97TA115Accident · Minor injuriesFinal reportPiper PA-18-150 · Laredo, TXthe pilot allowed the airplane to get into an excessive rate of descent, during approach for an off-airport landing.Mar 3, 1997 · N2320P · Substantial damageNTSB DCA97IA030Incident · No injuriesIncident investigationFinal reportBoeing 727F · Atlanta, GAA jammed elevator resulting from a backed-off elevator trim tab nut.Mar 3, 1997 · N465FE · Minor damageNTSB NYC97LA059Accident · No injuriesLimited investigationFinal reportBeech J35 · Pittstown, NJthe pilot's placing the fuel selector in the improper position causing fuel starvation and a loss of engine power. The loss of engine power resulted in a forced landing on the runway during an aborted landing.Mar 2, 1997 · N88AA · Substantial damageNTSB MIA97LA091Accident · 1 fatalLimited investigationFinal reportHackett Windex 1200C · Wauchula, FLfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall/spin and subsequent collision with terrain.Mar 2, 1997 · N1201G · DestroyedNTSB FTW97IA112Incident · No injuriesIncident investigationFinal reportBoeing 757-2S7 · Denver, COthe pilot-in-command's failure to comply with company procedures/directives to not taxi the aircraft beneath the bridge/overpass, and his misjudgment of clearance between the vertical stabilizer and the bridge/overpass.Mar 2, 1997 · N902AW · Minor damageNTSB CHI97LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2Q8 · Chicago, ILClear air turbulence.Mar 2, 1997 · N755AT · No damageNTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.Mar 2, 1997 · N9420W · Substantial damageNTSB MIA97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Jackson, TNThe pilot's failure to maintain an adequate visual lookout while taxing. The reduced visibility was a factor.Mar 1, 1997 · N98991 · Substantial damageNTSB LAX97LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8B · Parker, AZthe pilot's inadequate in-flight planning, which resulted in an excessive descent and subsequent hard landing, due to a drop in fuel pressure along with shifting winds at low altitude.Mar 1, 1997 · N9033H · No damageNTSB FTW97LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Pueblo, COImproper repair to the nose landing gear assembly. A factor was binding of the nose gear extension assembly due to the improper repair.Mar 1, 1997 · N2396S · Substantial damageNTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.Feb 28, 1997 · N49205 · DestroyedNTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…Feb 28, 1997 · N89WL · DestroyedNTSB MIA97LA088Accident · Minor injuriesLimited investigationFinal reportLearjet LR35 · Greenville, SCThe pilot-in-command's failure to achieve the proper touchdown point on a known wet runway, resulting in a subsequent overrun and on ground collision with a ditch.Feb 27, 1997 · N440HM · DestroyedNTSB MIA97LA087Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Calhoun, GAThe pilot-in-command's improper fuel management and improper positioning of the fuel selector valve to the empty fuel tank. Factors in the accident were: the PIC's improper in-flight planning and decision, his failure to list an alternate airport, and his…Feb 27, 1997 · N72GL · DestroyedNTSB SEA97LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · College Place, WAThe certified flight instructor's improper in-flight decision to continue the landing attempt and not perform a go-around, her failure to attain the proper touchdown point, and her failure to apply proper remedial action. A contributing factor was the…Feb 26, 1997 · N48965 · Substantial damage