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 BFO91LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Harrisonburg, VAThe pilot's failure to maintain directional control. Contributing to the accident was premature raising of the flaps, and inadequate airspeed.Feb 3, 1991 · N19240 · DestroyedNTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.Feb 3, 1991 · N4749P · No damageNTSB ATL91FA047Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Cordele, GAFailure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.Feb 3, 1991 · N9209P · DestroyedNTSB SEA91LA052Accident · No injuriesLimited investigationFinal reportCessna 182Q · Anacortes, WAThe pilot improper planning/decisions. The high wind was a factor.Feb 2, 1991 · N96378 · Substantial damageNTSB NYC91LA071Accident · No injuriesLimited investigationFinal reportRobinson R-22 Alpha · Coram, NYThe pilot-in-command's failure to maintain rotor RPM and misjudging the height of the flare during a precautionary autorotative landing, resulting in a roll over during the landing flare touchdown.Feb 2, 1991 · N8555K · Substantial damageNTSB NYC91LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHFuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.Feb 2, 1991 · N13341 · Substantial damageNTSB NYC91FA069Accident · 3 fatalField investigationFinal reportCessna 172P · Augusta, METhe pilot rotated the airplane at an improper speed, then allowed the climb angle to become too steep, causing an inadvertent stall at too low an altitude to allow recovery. Contributing factors in the accident were; the pilot failed to use all of the…Feb 2, 1991 · N62746 · DestroyedNTSB DEN91LA040Accident · No injuriesLimited investigationFinal reportAerostar RX7 · Durango, COThe pilot's failure to maintain obstacle clearance. Factors were: the unfavorable winds and the high obstructions in the flight path.Feb 2, 1991 · N35773 · Substantial damageNTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.Feb 2, 1991 · N1437D · Substantial damageNTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…Feb 2, 1991 · N388US · 2 aircraft · DestroyedNTSB BFO91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wise, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was unsuitable terrain on the emergency landing field.Feb 2, 1991 · N7816D · Substantial damageNTSB ATL91LA049Accident · No injuriesLimited investigationFinal reportBeech V35B · Advance, NCThe pilot's diverted attention and failure to maintain directional control during the takeoff. A factor was the malfunctioning magneto which resulted in the engine sputter.Feb 2, 1991 · N74LE · Substantial damageNTSB ANC91FA023Accident · No injuriesField investigationFinal reportChampion 7EC · Eagle River, AKThe pilot-in-command's failure to maintain clearance from the terrain.Feb 2, 1991 · N8988R · Substantial damageNTSB LAX91LA090Accident · Serious injuriesLimited investigationFinal reportRiddell Lancair 235 · Agua Caliente, CAThe failure of the propeller blades due to a weakening of the wood structure due to acid hydrolysis. A factor in the accident was the inadequate maintenance of the propeller assembly by allowing exposure to excessive moisture and heat.Feb 1, 1991 · N17S · Substantial damageNTSB CHI91LA086Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INSeparation of the aft, upper, accessory case cowl assembly from the airplane, and inadequate airframe equipment provided by the manufacturer.Feb 1, 1991 · N5584M · Substantial damageNTSB ATL91IA044Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Charlotte, NCThe failure of the captain to follow checklist procedures, resulting in a flight with the cabin door unsecured, and the subsequent loss of the cabin door.Feb 1, 1991 · N844AE · Minor damageNTSB MIA91FA076Accident · Serious injuriesField investigationFinal reportAerospatiale SA-341G · Miami, FLThe pilot in command's failure to initiate an autorotation in timely manner following loss of engine power for undetermined reasons resulting in loss of rotor RPM and an uncontrolled descent and impact with the terrain.Jan 31, 1991 · N341WC · DestroyedNTSB DCA91MA019Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Beckley, WVFlight into known adverse weather conditions by the pilot, which resulted in ice accumulation on the aircraft and subsequent loss of aircraft control (tail plane stall) as the flaps were fully extended. Factors related to the accident were: the pilot's…Jan 31, 1991 · N167PC · DestroyedNTSB NYC91LA068Accident · No injuriesLimited investigationFinal reportBeech 200 · Johnstown, PAThe pilot's failure to maintain proper directional control of the airplane during landing, resulting in a collision with a snow bank and runway marker. A factor relating to the accident was the low visibility during landing.Jan 30, 1991 · N30SE · Substantial damageNTSB LAX91FA086Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Dunsmuir, CAThe pilot's delayed go-around attempt and improper use of carburetor heat. Contributing to the accident was a degradation of engine power due to fuel contamination from sand and rust.Jan 30, 1991 · N7194P · DestroyedNTSB MIA91FA075Accident · 1 fatalField investigationFinal reportCessna 210L · Orlando, FLThe pilot's failure to maintain aircraft control in instrument conditions and his spatial disorientation. Factors were a failure of the vacuum pump and the pilot's lack of recent experience in partial panel instrument flying or training.Jan 28, 1991 · N210GC · DestroyedNTSB LAX91LA084Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Owayhee, NVThe failure of the pilot to maintain directional control. A factor was sun glare.Jan 28, 1991 · N5653Y · DestroyedNTSB CHI91LA083Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Indianapolis, INVisual outlook was not possible and aircraft directional control was not maintained by the pilot. Factors related to the accident were dense fog, early dawn light conditions, poor judgement and over confidence in personal ability by the pilot and trees in the…Jan 28, 1991 · N6610S · Substantial damageNTSB ANC91LA022Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-3 · Nome, AKThe failure of the 1, 2, 6, 7, 8 and 9 piston linkrods which were broken at the master rod attach end. Contributing to the accident was the rough, uneven terrain.Jan 28, 1991 · N212NY · Substantial damageNTSB NYC91FA067Accident · 4 fatalField investigationFinal reportMBB BK 117 B-1 · Sonestown, PAThe pilot's inadequate preflight planning to assure that the intended course and altitude provided adequate terrain clearance. Contributing factor(s) was: the dark night, snow and mountainous terrain.Jan 27, 1991 · N891GM · DestroyedNTSB NYC91DFA02Accident · 1 fatalFinal reportHayes Kolb/Twinstar · Round Lake, NYIn-flight structural failure of the outboard wing attachment fittings on both wings due to an undetermined reason.Jan 27, 1991 · N71817 · Substantial damageNTSB MIA91WA074Accident · Minor injuriesForeign investigationCessna 152 · Mores Island, BahamasJan 27, 1991 · N48793 · Substantial damageNTSB MIA91LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, FLPartial loss of engine power after takeoff due to undetermined reasons resulting in the emergency descent and in-flight collision with the power line then the ground.Jan 27, 1991 · N610FL · Substantial damageNTSB LAX91LA083Accident · No injuriesLimited investigationFinal reportCessna 172P · Sedona, AZThe failure of the pilot to maintain directional control of the aircraft.Jan 27, 1991 · N54863 · Substantial damageNTSB FTW91LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind condition that existed at the time of the accident.Jan 27, 1991 · N67650 · Substantial damageNTSB FTW91FA035Accident · 2 fatalField investigationFinal reportBell 206L-1 · S Tim Blk 198For undetermined reason(s), the helicoper crashed at sea (gulf of Mexico) in an area with a low ceiling, rain, and thunderstorms.Jan 27, 1991 · N39HC · DestroyedNTSB FTW91FA033Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oppella, ARThe pilot's failure to maintain a proper climb rate following loss of his visual references and allowing himself to become diverted during the takeoff. Factors in the accident were interrupted instrument lighting and the dark night conditions.Jan 27, 1991 · N291R · DestroyedNTSB CHI91LA085Accident · No injuriesLimited investigationFinal reportMooney M2OE · Rush Hill, MOThe pilot's failure to refuel the airplane. A factor related to the accident was unsuitable terrain.Jan 27, 1991 · N1314W · Substantial damageNTSB ATL91FA043Accident · 1 fatalField investigationFinal reportCessna 337C · Bryson City, NCThe inadvertent flight into instrument meteorological conditions in mountainous terrain by the noninstrument rated pilot.Jan 27, 1991 · N2589S · DestroyedNTSB NYC91LA066Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Williamstown, MAThe failure of the pilot to retract the speed brakes during the preflight, which resulted in the tow airplane being unable to attain sufficient altitude prior to releasing the glider, and the subsequent landing of the glider on unsuitable terrain.Jan 26, 1991 · N5763S · Substantial damageNTSB LAX91LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Show Low, AZEngine failure due to fuel exhaustion. A factor was inoperative fuel gauges.Jan 26, 1991 · N8900X · DestroyedNTSB LAX91FA081Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAA loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the ensuing emergency landing.Jan 26, 1991 · N210TW · DestroyedNTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.Jan 26, 1991 · N4035B · DestroyedNTSB CHI91LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MNInadequate compensation or wind conditions, and failure to maintain directional control by the pilot. Factors related to the accident are lack of total experience, and the crosswind conditions.Jan 26, 1991 · N9419E · Substantial damageNTSB CHI91LA082Accident · No injuriesLimited investigationFinal reportCessna 170B · Rochester, INThe pilot-in-command's inadequate compensation for wind conditions. A factor contributing to the accident was the crosswind.Jan 26, 1991 · N4414B · Substantial damageNTSB SEA91TA003Accident · No injuriesFinal reportPiper PA-34 · Pinedale, WYThe pilot's failure to attain proper runway alignment during landing. A contributing factor was a snow covered runway.Jan 25, 1991 · N8372Z · Substantial damageNTSB MIA91LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-B-310 · Fernandina Bch, FLDelay by the pilot to perform a missed approach and failure to correct the descent before impact with terrain.Jan 25, 1991 · N31HL · Substantial damageNTSB LAX91LA099Accident · Minor injuriesLimited investigationFinal reportWalter Chandler Phoenix · Cayucos, CAThe pilot's selection of unsuitable terrain and his misjudgment of the proper touch down point following the pilot's decision to make a precautionary landing. Contributing to the accident was an in-flight separation of the trim tab rod from the trim tab,…Jan 25, 1991 · N2027C · Substantial damageNTSB LAX91LA079Accident · No injuriesLimited investigationFinal reportRobinson R-22 HP · Scottsdale, AZThe failure of the drive belts due to excessive wear of the clutch assembly upper sheave and the pilot's inaccurate flare during the termination of the autorotation. A factor in the accident was the inadequate design of the clutch assembly upper sheave.Jan 25, 1991 · N21439 · Substantial damageNTSB CHI91LA087Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Indianapolis, INThe pilot's failure to use proper procedures and the improper use of the throttles.Jan 25, 1991 · N815AA · No damageNTSB NYC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Celina, OHThe pilot-in-command's improper use of the powerplant controls, magnetos and brakes.Jan 24, 1991 · N8385S · Substantial damageNTSB NYC91LA064Accident · 1 fatalLimited investigationFinal reportBeech 58 · Batavia, NYThe failure of the pilot to ensure an adequate amount of fuel was on board for the planned flight which resulted in a double power loss due to the fuel exhaustion.Jan 24, 1991 · N73JP · DestroyedNTSB MIA91LA072Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Fort Myers, FLIn-flight encounter with a downdraft which caused the airspeed to decrease below vso resulting in an inadvertent stall/mush.Jan 24, 1991 · N1279D · Substantial damageNTSB LAX91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe student pilot's improper bounced landing recovery technique. A factor in the accident was the pilot's limited flight experience.Jan 24, 1991 · N93574 · Substantial damageNTSB CHI91LA076Accident · No injuriesLimited investigationFinal reportCessna 320 · Middleton, WIThe main landing gear collapsed during landing rollout due to extreme cold temperatures. A factor related to the accident was a snowbank adjacent to the runway.Jan 24, 1991 · N4112T · Substantial damage