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 ANC98FA006Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot's intentional flight into adverse weather. Related factors were the low ceilings, mountainous terrain, and self induced pressure by the pilot to complete the flight and return for the evening.Oct 23, 1997 · N30505 · DestroyedNTSB FTW98FA028Accident · 1 fatalField investigationFinal reportWeatherly 620B · Cee Vee, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight.Oct 22, 1997 · N46278 · DestroyedNTSB NYC98FA017Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA-200 · Radnor, OHThe failure of the pilot to obtain the proper altitude/clearance above the terrain, to perform an aerobatic maneuver. A factor was the pilot's lack of total experience in make and model.Oct 21, 1997 · N11EX · DestroyedNTSB ATL98LA006Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · West Palm Beach, FLthe pilot's inadvertent use of the wrong runway, and his improper decision to continue the approach behind a large airplane (MD-80), which resulted in a wake turbulence encounter, loss of aircraft control, and collision with terrain.Oct 21, 1997 · N534SS · Substantial damageNTSB ANC98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of engine power due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the lack of suitable terrain for a forced landing.Oct 21, 1997 · N7049K · Substantial damageNTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.Oct 20, 1997 · N2200J · Substantial damageNTSB NYC98FA016Accident · 1 fatalField investigationFinal reportCessna 182P · Morgantown, WVThe loss of engine power due to carburetor ice and the pilot's failure to follow ATC instructions during the emergency descent.Oct 20, 1997 · N9388G · DestroyedNTSB LAX98LA015Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Chino, CAfuel starvation resulting from the pilot's inadequate in-flight planning and improper fuel management. Contributing factors were the nighttime conditions and the rough/uneven terrain.Oct 20, 1997 · N67736 · Substantial damageNTSB FTW98LA027Accident · No injuriesLimited investigationFinal reportHelio H-800 · Ogden, UTfailure of the tail wheel assembly, which rendered the aircraft uncontrollable during landing roll.Oct 20, 1997 · N40013 · Substantial damageNTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.Oct 20, 1997 · N6206K · DestroyedNTSB CHI98LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · St Charles, MOfailure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.Oct 20, 1997 · N9449V · Substantial damageNTSB ATL98LA005Accident · No injuriesLimited investigationFinal reportMooney M20C · Hendersonville, NCThe undetermined malfunction of the nose gear steering assembly that resulted in the loss of directional control during a full stop landing. A factor was the rough and uneven runway condition. .Oct 20, 1997 · N3426X · Substantial damageNTSB ATL98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Blakley, GAthe pilot misjudge clearance from trees during pull-up from a swath run. The obstructions (power line and trees) were related factors.Oct 20, 1997 · N9567P · DestroyedNTSB ANC98IA004Incident · No injuriesIncident investigationFinal reportCessna 208B · Kasigluk, AKinadequate inspection of the aileron by company maintenance personnel, and the pilot's inadequate preflight inspection of the aileron, which led to the jamming of the left aileron due to loose balance weight retaining screws.Oct 20, 1997 · N9304F · No damageNTSB SEA98LA006Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Winston, MTFuel starvation due to fuel flow restriction from a failed carburetor automatic mixture control device. Factors include night light conditions for the forced landing.Oct 19, 1997 · N47AH · Substantial damageNTSB SEA98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vashon, WAA misjudged soft field takeoff. Factors include wet grass.Oct 19, 1997 · N5987F · Substantial damageNTSB LAX98LA014Accident · No injuriesLimited investigationFinal reportStinson AT-19 · North Las Vegas, NVThe pilot of the Stinson AT-19, N88793, inadequate visual lookout and his failure to perform clearing S-turns while taxiing. A related factor was the inherent forward visual restriction of the aircraft's conventional landing gear design.Oct 19, 1997 · N88793 · 2 aircraft · Substantial damageNTSB IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.Oct 19, 1997 · N9614B · Substantial damageNTSB FTW98LA026Accident · No injuriesLimited investigationFinal reportCessna 182P · Thompsons, TXThe loss of engine power resulting from a disconnected carburetor float due to improper maintenance. A factor was the lack of suitable terrain for a forced landing.Oct 19, 1997 · N10DG · Substantial damageNTSB FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.Oct 19, 1997 · N42AM · Substantial damageNTSB FTW98LA022Accident · No injuriesLimited investigationFinal reportCessna 150G · Tyler, TXThe failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.Oct 19, 1997 · N3916J · 2 aircraft · Minor damageNTSB FTW98LA018Accident · Serious injuriesLimited investigationFinal reportMooney M20F · College Station, TXThe pilot's failure to maintain airspeed during a go-around. Factors were :the pilot's premature retraction of the flaps, his lack of total experience in the airplane, the dark night illumination, pilot fatigue, and pressure induced by the passengers to…Oct 19, 1997 · N7433V · Substantial damageNTSB ATL98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Miami, FLexcessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.Oct 19, 1997 · N7814U · Substantial damageNTSB SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.Oct 18, 1997 · N5482U · Substantial damageNTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.Oct 18, 1997 · N7583 · Substantial damageNTSB FTW98LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent collapse of the nose gear.Oct 18, 1997 · N93116 · Substantial damageNTSB CHI98LA019Accident · No injuriesLimited investigationFinal reportPiper J3L-65 · Reeseville, WIfailure of the normal braking system, due to a low level of brake fluid. Factors relating to the accident were: inadequate inspection of the aircraft by other maintenance personnel, the pilot's failure to check the brakes after brake maintenance/inspection,…Oct 18, 1997 · N33252 · Substantial damageNTSB CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.Oct 18, 1997 · N88119 · Substantial damageNTSB SEA98LA003Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Galata, MTThe pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…Oct 17, 1997 · CFOJT · Substantial damageNTSB MIA98LA013Accident · No injuriesLimited investigationFinal reportCessna 172G · Panacea, FLThe pilot's improper use of carburetor heat resulting in loss of engine power due to carburetor icing and an in flight collision with trees during a forced landing.Oct 17, 1997 · N4690L · Substantial damageNTSB MIA98LA012Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Pompano Beach, FLThe improper use of collective control by the dual student which prevented the flight instructor from stopping an uncontrolled roll to the left.Oct 17, 1997 · N333PH · Substantial damageNTSB CHI98LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Quincy, ILimproper in-flight planning/decision by the flight instructor (CFI), by switching 'OFF' the fuel selector valve of the single-engine airplane (starving the engine of fuel) to 'simulate' an emergency. Factors relating to the accident were: the soft and uneven…Oct 17, 1997 · N68299 · DestroyedNTSB SEA98LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDThe pilot's failure to maintain directional control during landing. Factors were inattention and fatigue.Oct 16, 1997 · N7507D · Substantial damageNTSB LAX98LA012Accident · Serious injuriesLimited investigationFinal reportMikoyan MiG MIG 15UTI · Reno, NVThe pilot's misjudged landing flare and improper bounced landing recovery technique.Oct 16, 1997 · N17KM · Substantial damageNTSB FTW98LA030Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Welsh, LAthe pilot's failure to maintain control of the helicopter, while maneuvering to avoid an obstruction. The abrupt maneuver was a related factor.Oct 16, 1997 · N7104J · Substantial damageNTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.Oct 16, 1997 · N7527K · Substantial damageNTSB FTW98IA019Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Seattle, WAMaintenance personnel's failure to properly secure the left off-wing slide door after routine slide replacement, allowing an inflight separation of the slide. Factors were inadequate training of maintenance personnel and inadequate written instructions by the…Oct 16, 1997 · N581UA · Minor damageNTSB NYC98LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Piqua, OHThe student pilot's inadequate compensation for the wind condition. A factor in this accident was the crosswind condition.Oct 15, 1997 · N6154Q · Substantial damageNTSB NYC98LA013Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Pittsburgh, PAthe tug driver's failure to obey a stop sign and his failure to yield right-of-way to the airplane.Oct 15, 1997 · N162ZV · Substantial damageNTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.Oct 15, 1997 · N227AV · Substantial damageNTSB FTW98TA051Incident · No injuriesFinal reportCessna P210N · Bryce Canyon, UTThe failure of the resistor (inverter) in the door seal pressurization air pump due to continuous operation. Factors were a failure in the door seal pressurization system, its inadequate design by the manufacturer, its inadequate written instructions for…Oct 15, 1997 · N731NX · Minor damageNTSB FTW98LA016Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Altus, OKThe loss of engine power due to the cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Oct 15, 1997 · N8819H · Substantial damageNTSB FTW98LA015Accident · No injuriesLimited investigationFinal reportSego Tool Hawk H2X · Tooele, UTThe pilot's failure to maintain aircraft control. Contributing was the inadequate design of the flight control systems, resulting in slow response to pilot input.Oct 15, 1997 · N4412X · Substantial damageNTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…Oct 15, 1997 · N557DC · Substantial damageNTSB ATL98FA002Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Kennesaw, GAthe pilot's improper emergency procedures and subsequent loss of aircraft control, while attempting to maneuver for a precautionary landing. A factor relating to the accident was: partial loss of power in one or both engines for undetermined reason(s).Oct 15, 1997 · N315K · DestroyedNTSB ANC98LA003Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sutton, AKThe pilot's failure to maintain clearance between the tail rotor and the external long line cable, and the subsequent entanglement of the tail rotor with the long line.Oct 15, 1997 · N86TA · Substantial damageNTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.Oct 14, 1997 · N62264 · Substantial damageNTSB FTW98RA011Accident · Minor injuriesForeign investigationAyres S2R-T65 · Neiva, ColombiaOct 14, 1997 · PN259NTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.Oct 14, 1997 · N731GY · DestroyedNTSB NYC98LA011Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26A · Fairfield, PAThe improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.Oct 13, 1997 · N1154N · Minor damage