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 LAX89FA042Accident · 1 fatalField investigationFinal reportCessna 172N · Fremont, CAThe newly certificated private plt reportedly was emotionally disturbed about his employment & personal life situation. He loved flying & flew to release anxiety. Near midnight the plt departed for a short x-c flight during which he became disoriented. The…Nov 17, 1988 · N6256F · DestroyedNTSB FTW89LA021Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico)Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.Nov 17, 1988 · N2780W · Substantial damageNTSB CHI89FA026Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Chicago, ILThe first takeoff was aborted due to a perceived engine problem. Six minutes later on second takeoff, the aircraft climbed to 50 feet, drifted to the right, rolled right and impacted in the infield. This was a single pilot operation in a complex aircraft.…Nov 17, 1988 · N271MA · DestroyedNTSB CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.Nov 17, 1988 · N3RJ · DestroyedNTSB ATL89LA040Accident · No injuriesLimited investigationFinal reportCessna 170 · Batavia, OHAfter about 3 hours and 20 mins of flight the pilot experienced a complete power failure. He attempted to reach the closest airport, but was forced to land in a field 3 miles short. The pilot had estimated that he had 4 hrs fuel. At about 9 gph and 33.5 gals…Nov 17, 1988 · N4137V · Substantial damageNTSB ATL89LA034Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Uriah, ALWhile cruising at 6500 ft, the eng lost power & the prop stopped windmilling. The plt elected to land on a highway. Drg the landing, the right wing hit overhanging tree limbs which yawed the acft off the right side of the road & down an embankment. The eng…Nov 17, 1988 · N5021P · Substantial damageNTSB NYC89FA032Accident · 1 fatalField investigationFinal reportMooney M20K · Holden, MAInflight loss of control due to spatial disorientation and contact with trees prior to regaining control after the pilot experienced an unknown problem with the autopilot. Contributing was the lack of recent night experience.Nov 16, 1988 · N1170Z · DestroyedNTSB MKC89IA024Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-31 · Minneapolis, MNThe failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation.Nov 16, 1988 · N965VJ · Minor damageNTSB MIA89LA034Accident · No injuriesLimited investigationFinal reportBeech V35B · Brandon, FLThe plt rprtd that he diverted to an alternate arpt due to fog at his destn. While en route at aprx 2000 ft MSL, the eng lost power. The plt said he repositioned the fuel selector & turned on the boost pump, but his attempts to restart the eng were…Nov 16, 1988 · N2255N · Substantial damageNTSB MIA89IA035Incident · No injuriesIncident investigationFinal reportBoeing 707-355C · Sanford, FLThe non-type rated FAA flight test engineer executed a visual approach and was observed to be erratic and flying at v-ref when he chopped the power at 50 ft AGL and the aircraft landed hard. The instructor pilot then took control of the aircraft and executed…Nov 16, 1988 · N707MB · Minor damageNTSB LAX89LA044Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Inyokern, CAThe pilot stated that, 'I landed in an open unpopulated area for the mechanic ... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…Nov 16, 1988 · N552CS · DestroyedNTSB DEN89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Chinook, MTThe student plt was flying cross country, solo, to take a private plt checkride. He said he became lost and flew until the fuel was exhausted. He selected a snow covered field and landed. At touchdown, the nose gear dug in and the acft nosed over.Nov 16, 1988 · N28EF · Substantial damageNTSB DEN89FA034Accident · 2 fatalField investigationFinal reportCessna 421 · Tooele, UTNov 16, 1988 · N222BL · Substantial damageNTSB NYC89LA031Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Latrobe, PALoss of directional control while taxiing at an excessive speed.Nov 15, 1988 · N30FA · Substantial damageNTSB MIA89WA071Accident · Serious injuriesForeign investigationAirbus Industrie A-300B4-203 · Panama City, PanamaNov 15, 1988 · N205PA · No damageNTSB FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNov 15, 1988 · N1639B · Substantial damageNTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINov 15, 1988 · N86ER · Substantial damageNTSB BFO89LA010Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Dublin, WVThe pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding…Nov 15, 1988 · N88054 · Substantial damageNTSB ATL89LA038Accident · Serious injuriesLimited investigationFinal reportCessna 152F · Harkers Island, NCThe plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…Nov 15, 1988 · N8225F · DestroyedNTSB ATL89LA037Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Lawrenceville, GAImproper repair and/or modification of the carburetor airbox by unknown person(s), and the subsequent failure of maintenance personnel to detect the improper repair/modification during annual inspection(s), which led to a loss of power due to carburetor…Nov 15, 1988 · N96164 · Substantial damageNTSB NYC89LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawling, NYOff airport landing in unsuitalbe terrain following a power loss caused by loss of lubrication due to spalling on the camshaft and corresponding tappet body faces.Nov 14, 1988 · N54394 · Substantial damageNTSB NYC89IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Boston, MAFailure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local…Nov 14, 1988 · N555PE · 2 aircraft · Minor damageNTSB NYC89FA029Accident · 3 fatalField investigationFinal reportRyan Navion A · Franklin, PADue to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the…Nov 14, 1988 · N5164K · DestroyedNTSB MIA89FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Jacksonville, FLDrg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…Nov 14, 1988 · N8342L · DestroyedNTSB FTW89DQG02Accident · 1 fatalFinal reportPiper PA-25 · Amarillo, TXFailure on the part of the pilot to maintain the proper airspeed for the maneuver being performed, followed by a stall at an altitude insufficient to recover.Nov 14, 1988 · N8547L · DestroyedNTSB DEN89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 310H · Carlsbad, NMOn an IFR business/training flt, the ATP plt made an unscheduled fuel stop. On a practice ILS apch to rwy 3, circling to land rwy 21, the acft yawed hard rt and the plt lost directional control. The plt said it sounded and felt like the rt engine had lost…Nov 14, 1988 · N1044Q · Substantial damageNTSB DEN89LA031Accident · Serious injuriesLimited investigationFinal reportSkypower 6 · Circleville, UTThe commercial balloon pilot and a commercial rated passenger were making an overnight flight. The balloon was equipped with instruments and equipment that allowed flight following by los angeles ARTCC. The flight became engulfed in a cold front and endured…Nov 14, 1988 · N46SP · Substantial damageNTSB CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…Nov 14, 1988 · N6292 · Substantial damageNTSB CHI89DEV03Accident · No injuriesFinal reportRyan Navion · Lane, ILAirplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…Nov 14, 1988 · N91411 · Substantial damageNTSB ATL89FA035Accident · 2 fatalField investigationFinal reportHughes 269C · Mohawk, TNThe helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…Nov 14, 1988 · N9575F · DestroyedNTSB ANC89LA017Accident · No injuriesLimited investigationFinal reportCessna A185F · Kasitsna Bay, AKThe plt was landing on a beach to deliver mail. He rprtd that during touchdown, the acft skipped about 50 ft before settling to the ground, then it remained in contact with the ground & rolled straight ahead. During the landing roll, the acft nosed over. The…Nov 14, 1988 · N4759E · Substantial damageNTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.Nov 13, 1988 · N722BH · Substantial damageNTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…Nov 13, 1988 · N2158P · Substantial damageNTSB MIA89IA032Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Melbourne, FLThe plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had…Nov 13, 1988 · N32393 · Minor damageNTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…Nov 13, 1988 · N1259M · DestroyedNTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…Nov 13, 1988 · N43603 · Substantial damageNTSB DEN89LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Riverton, WYThe instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…Nov 13, 1988 · N8045B · Substantial damageNTSB CHI89DEV02Accident · 1 fatalFinal reportAir Command 503 · Sullivan, ILThe pilot failed to maintain control of the aircraft.Nov 13, 1988 · UNREG · DestroyedNTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…Nov 13, 1988 · N993NA · Substantial damageNTSB ATL89LA032Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Marietta, GADuring preflt 'run-up' at the end of the active rwy, the right brake failed and the airplane pivoted left while the engine was at a high power setting. The plt rpted that things happened so fast that he may have added power while attempting to reduce power.…Nov 13, 1988 · N431T · Substantial damageNTSB ATL89FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, FLAircraft departed on a cross country instructional flight. The aircraft landed for fuel at orlando int'l and departed VFR. There were no witnesses. The accident site was located by ELT signal in a treeline that bordered the west end of a large open pasture.…Nov 13, 1988 · N69175 · DestroyedNTSB SEA89LA018Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Gamble, WAForeign national pilot was obtaining helicopter instruction. On solo flt to practice lndgs in unimproved terrain, touched down on stump with one skid and rolled over. Plt cited temporary pwr loss during approach. Investigation found no engine malfunction.Nov 12, 1988 · N2460P · Substantial damageNTSB NYC89LA026Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Pittstown, NJUncontrolled contact with trees after the pilot lost directional control of the aircraft during an attempted landing.Nov 12, 1988 · N3208T · Substantial damageNTSB MIA89IA031Incident · No injuriesIncident investigationFinal reportCessna 210L · Stuart, FLWhile hand-propping the engine with a passenger in the right front seat, the eng started. The acft travelled uncontrolled into a parked unoccupied acft. Both acft sustained substantial damage. The plt on the ground & the passenger in the acft were not…Nov 12, 1988 · N2267S · Minor damageNTSB MIA89IA030Incident · No injuriesIncident investigationFinal reportHughes 269A · Daytona Beach, FLDuring normal cruise flt, the main rotor drive system failed for undetermined reason(s). Grass was ignited by exhaust gasses after touchdown, resulting in fire, destroying the helicopter. Examination of eng compartment revealed no evidence of catastrophic…Nov 12, 1988 · N37632 · No damageNTSB LAX89LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Page, AZFailure of the number five cylinder piston, for undetermined reasons, initiating an engine failure and subsequent forced landing in unsuitable terrain.Nov 12, 1988 · N42908 · Substantial damageNTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…Nov 12, 1988 · N5594D · DestroyedNTSB LAX89LA046Accident · No injuriesLimited investigationFinal reportUnivair Taylorcraft BC12-D · Kawaihae, HIDuring a pleasure flight, the pilot intentionally shut down the engine and was flying the airplane similar to a sailplane. To restart the engine, he would dive the airplane to attain enough speed to windmill the prop. Just before the accident, he allowed the…Nov 12, 1988 · N5496V · Substantial damageNTSB LAX89LA045Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Eureka, CADuring the takeoff run on calm water, the floatplane pilot noticed three pylons ahead. He felt there was insufficient space to abort, so he continued the takeoff. Just before reaching the pylons, he rotated the airplane in an effort to lift-off & clear the…Nov 12, 1988 · N7904V · Substantial damageNTSB BFO89LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Topping, VAThe pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…Nov 12, 1988 · N73114 · 2 aircraft · Minor damage