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 MIA86LA133Accident · No injuriesLimited investigationFinal reportBell 206-L-3 · Miami Shores, FLThe plt stated that he experienced generator failure upon departure from key west & elected to continue his flt to opa-locka, FL, making two stops enroute. He noted that his battery was dead after passing ocean reef, landed at watson island & then took off…Apr 25, 1986 · N71FW · Substantial damageNTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…Apr 25, 1986 · N401NA · Substantial damageNTSB LAX86LA190Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe plt reported that while on final apch to land, a moderate crosswind prevailed. Before reaching the rwy threshold the wind appeared to stop. When he began to flare a violent wind gust from the right lifted the right wing. Before he could reestablish…Apr 25, 1986 · N714AW · Substantial damageNTSB DEN86LA119Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Santa Fe, NMAccording to the student plt, he was attempting to hover the helicopter when he encountered turbulence. The student plt stated that the hard landing which followed resulted in spreading the skids & severing the tailboom.Apr 25, 1986 · N4073G · Substantial damageNTSB DEN86FA120Accident · Serious injuriesField investigationFinal reportConvair 580 · Denver, CON73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…Apr 25, 1986 · N73104 · No damageNTSB CHI86FA129Accident · Minor injuriesField investigationFinal reportBell 222B · Chicago, ILThe aircraft had just discharged two passengers on the rooftop helipad and was preparing for departure. The aircraft was picked up to a hover and the tailrotor struck a heliport surface perimeter light. The tailrotor separated from the aircraft and the…Apr 25, 1986 · N660DD · Substantial damageNTSB ATL86LA118Accident · No injuriesLimited investigationFinal reportTaylorcraft BLT-65 · Mount Airy, NCThe pilot stated that the engine lost power to idle RPM followed by a forced landing in trees. Examination of the aircraft determined that a snap ring which held the throttle cable housing in place in the instrument panel came loose. Without the snap ring the…Apr 25, 1986 · N27529 · Substantial damageNTSB SEA86LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mattawa, WAShortly after takeoff a loss of pwr occurred accompanied by an eng vibration. A forced landing was made onto a highway where a x-wind existed. Directional control was lost and the acft veered into a ditch and struck a fence before coming to a stop. No reason…Apr 24, 1986 · N57608 · Substantial damageNTSB LAX86LA191Accident · No injuriesLimited investigationFinal reportCessna 150J · Flagstaff, AZThe pilot was flying a round-robin flight from cottonwood, AZ to page, AZ, and return. The pilot had landed at page, AZ. While on the return leg of the flight the pilot noted his fuel gauges were 'low' and diverted to Flagstaff, AZ. When the acft was…Apr 24, 1986 · N60126 · Substantial damageNTSB ANC86LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that the aircraft is not equipped with a header tank on the fuel system. The engine was starved of fuel when in a shallow dive.Apr 24, 1986 · N78564 · Substantial damageNTSB ANC86LA047Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yentna River, AKThe pilot stated that the aircraft began to settle; airspeed was 60 mph. The aircraft would not recover altitude with full power. The aircraft stalled and struck tree tops.Apr 24, 1986 · N170CH · Substantial damageNTSB SEA86LA109Accident · No injuriesLimited investigationFinal reportGrumman G164-A · Echo, ORA loss of power occurred shortly after takeoff on a downwind departure. A forced landing was accomplished onto a wheat field downhill. The aircraft nosed over during the landing roll. Post accident inspection of the aircraft disclosed fuel contamination.Apr 23, 1986 · N25SK · Substantial damageNTSB NYC86FA111Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Spring Valley, NYThe pax stated that he & the plt were at a bar where they had about three beers rpior to this flight. During the flight the pilot did several stalls and some aerobatic maneuvers. The pax was unnerved and told the plt that he wanted to return to the arpt.…Apr 23, 1986 · N44331 · DestroyedNTSB MKC86LA096Accident · No injuriesLimited investigationFinal reportCessna 182M · Mountain Home, ARThe acft nose gear collapsed during a hard landing. The plt stated that his original destination was gastons arpt, lakeview, AR, which has a turf rwy. There are three other arpts in close proximity to gastons, but all have paved rwys. He further stated that…Apr 23, 1986 · N71551 · Substantial damageNTSB MIA86LA130Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Panama City, FLThe plt stated that on his apch he had a gear down & locked indication but on landing rollout, the nose gear completely collapsed and the acft slid to a stop on the rwy. Post accident examination of the landing gear system revealed that the nose gear…Apr 23, 1986 · N90676 · Substantial damageNTSB LAX86LA189Accident · Serious injuriesLimited investigationFinal reportCessna 195A · San Rafael, CAThe two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…Apr 23, 1986 · N4496C · 2 aircraft · Substantial damageNTSB LAX86LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Kahului, HIA Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac…Apr 23, 1986 · N9288F · Substantial damageNTSB LAX86LA187Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Hemet, CAA glider struck wires while on final apch to a field. The plt indicated that he was towed to an alt of 5,000 ft MSL (aprx 3,500 ft AGL). On release, he encountered a downdraft of more than 500 ft per minute and was only able to stay airborne 6 to 7 minutes.…Apr 23, 1986 · N2032T · Substantial damageNTSB CHI86LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Gregory, MIThe CFI stated that the purpose of the flight was to look at property and give a bfr to his dual student. The aircraft struck wires while on approach to runway 23 at the smith farm airport. The CFI stated this accident could have been prevented had he used a…Apr 23, 1986 · N16047 · Substantial damageNTSB CHI86LA127Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Ft. Wayne, INApprox 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…Apr 23, 1986 · N8752F · DestroyedNTSB NYC86LA110Accident · No injuriesLimited investigationFinal reportCessna C-310R · Buffalo, NYThe pilot of the C-310R stated upon landing flare he heard a loud noise on the right side. His speed was such that he became airborne again on relanding right propeller blades struck runway. Aircraft suffered major wing and structural damage.Apr 22, 1986 · N1909G · Substantial damageNTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…Apr 22, 1986 · N4169U · Substantial damageNTSB MIA86LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Orlando, FLPlt extended landing gear while in the landing flare. The aircraft settled onto the landing gear doors as the landing gear was extending which prevented the landing gear from extending. The aircraft then settled onto its belly and skidded off the runway.Apr 22, 1986 · N6272V · Substantial damageNTSB MIA86LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng…Apr 22, 1986 · N528FT · Substantial damageNTSB MIA86LA127Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · San Juan, PRThe plt stated that on landing the acft started to porpoise. He lost control, the landing gear collapsed and the acft slid to a stop on the rwy.Apr 22, 1986 · N6155V · Substantial damageNTSB FTW86LA071Accident · No injuriesLimited investigationFinal reportCessna TU206G · Tomball, TXThe pilot reported that he failed to flare the aircraft when he touched down during landing at Tomball, TX. The aircraft bounced twice and the nosewheel dug into the dirt strip causing the aircraft to noseover.Apr 22, 1986 · N6272Z · Substantial damageNTSB CHI86LA125Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Noblesville, INTwo successful takeoffs and landings had previously been completed during the training flight. On the approach for the third landing, the crew received a three-green indication, but after touchdown, the nose gear folded and the aircraft settled on its nose.…Apr 22, 1986 · N39693 · Substantial damageNTSB NYC86FA112Accident · 1 fatalField investigationFinal reportCessna 310 · Lincoln, RIThe air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated…Apr 21, 1986 · N128K · DestroyedNTSB LAX86LA184Accident · No injuriesLimited investigationFinal reportCessna 310N · Fullerton, CAThe acft overran the rwy during an aborted takeoff. The plt had flown the acft the day prior on his bfr and conducted a 'thorough preflight' insp. On the day of the accident, he preflighted the acft again and flew it without incident. He then refueled the…Apr 21, 1986 · N4162Q · Substantial damageNTSB LAX86FA183Accident · 1 fatalField investigationFinal reportCessna 150B · Bermuda Dunes, CAThe purpose of the research & development flight was to document through the use of videotape the deployment & trajectory of a speciality parachute which was connected to a ballast bag. The plt, who was the designer of the device, utilized his experimental…Apr 21, 1986 · N1118Y · DestroyedNTSB FTW86LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Keller, TXThe pilot reported colliding with a ditch along side the runway at goode airport in Keller, TX, when he failed to maintain directional control on landing. There was substantial damage to the aircraft when the impact tore off the left strut, causing the left…Apr 21, 1986 · N8376R · Substantial damageNTSB CHI86LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Augusta, WIThe pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees…Apr 21, 1986 · N94586 · Substantial damageNTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…Apr 21, 1986 · N9220R · Substantial damageNTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…Apr 21, 1986 · N23DA · Substantial damageNTSB SEA86LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bonners Ferry, IDThe plt utilized updrafts to climb to 7800 ft to clear a mountain ridge which was covered with 'cap clouds'. On the lee side of the ridge a downdraft was experienced and the acft descended into the 'fog'. The plt reported the acft instruments were used to…Apr 20, 1986 · N70040 · DestroyedNTSB NYC86LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Matawan, NJThe local sightseeing flight departed marlboro airport at about 1300 hours and returned at about 1400 hours. Entered pattern downwind and flew a normal pattern and approach. During flare, the aircraft was hit by a gust of wind. After touchdown and during…Apr 20, 1986 · N47355 · Substantial damageNTSB NYC86FFJ01Accident · No injuriesFinal reportPiper J3C-65 · Bethany, NYThe acft crashed on the arpt after a turn of aprx 120 degrees to avoid 60 ft trees at the departure edge of the arpt. The plt had used the grass beside the airstrip because of standing water at places on the rwy. The takeoff run was started about 500 ft from…Apr 20, 1986 · N88379 · Substantial damageNTSB MKC86LA094Accident · No injuriesLimited investigationFinal reportBeech A-90 · West Memphis, ARThe plt made a landing to a rain slick rwy at West Memphis, Arkansas. The plt stated the acft hydroplaned and that braking was negligible. The pic's attempts to use the reversers resulted in the acft yawing. Wind shifts in the rain showers extended the acft's…Apr 20, 1986 · N772K · Substantial damageNTSB MKC86LA093Accident · No injuriesLimited investigationFinal reportBeech M-35 · Marshall, MOThe pilot stated that all the tanks were full when he departed springdale, Arkansas and he flew en route for one hour on the left tank and thirty minutes on the auxiliary tank. The aircraft performed routinely en route and during letdown to the Marshall…Apr 20, 1986 · N9726R · Substantial damageNTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.Apr 20, 1986 · N10600 · No damageNTSB MIA86LA125Accident · Minor injuriesLimited investigationFinal reportBeech B95A · St. Augustine, FLThe pilot in command did not assure that the fuel selector for the left engine was selected and in the detent prior to takeoff. On the initial climb the fuel selector moved slightly and the left engine failed due to fuel starvation. The pilot then did not…Apr 20, 1986 · N951Q · Substantial damageNTSB MIA86FA126Accident · Serious injuriesField investigationFinal reportBlythe Quickie · Eustis, FLThe student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…Apr 20, 1986 · N316Q · DestroyedNTSB LAX86MA186Accident · No injuriesMajor investigationFinal reportLTV Aerospace Industries A7E · Warner Springs, CAA rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating…Apr 20, 1986 · USN · 2 aircraft · Substantial damageNTSB LAX86LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAThe plt reported that he intended to fly to Lancaster to refuel. After being airborne for about 44 minutes & while entering the traffic pattern, the acft's engine exhausted its usable fuel. The plt attempted to glide to the rwy, but had insufficient altitude.…Apr 20, 1986 · N66459 · Substantial damageNTSB FTW86LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Lubbock, TXDuring an attempted go-around, after touching down past the runway mid-point, the pilot stated he was unable to obtain sufficient power during the go-around. The aircraft crashed 200 feet off the end of the runway. FAA inspectors on the scene stated that they…Apr 20, 1986 · N29612 · Substantial damageNTSB FTW86FRG18Accident · Serious injuriesFinal reportBaby Bird Q2-200 · Gerogetown, TXThe acft landed short of the rwy after losing partial pwr while maneuvering around the arpt. The plt had radioed that the eng was developing about 2000 RPM. The plt had reported throttle problems on previous flt. Due to impact damage it was not possible to…Apr 20, 1986 · N39943 · DestroyedNTSB DEN86LA118Accident · No injuriesLimited investigationFinal reportCessna 180G · Roosevelt, UTThe plt stated that after 'landing long', he decided to initiate a go-around. The plt said the aircraft he was piloting contacted a parked aircraft during the go-around which resulted in the accident.Apr 20, 1986 · N180BK · Substantial damageNTSB NYC86FGM01Accident · No injuriesFinal reportVere Eze Long EZE · Dorrseyville, PAThe homebuilt acft collided with a ditch during a forced lndg short of the rwy after a power loss during a test flt. The plt had noted smoke in the cockpit and a loss of oil pressure. As he returned to the arpt the eng began to run rough and surge before…Apr 19, 1986 · N40FP · Substantial damageNTSB LAX86FUJ01Accident · No injuriesFinal reportPiper PA-25-235 · Phoenix, AZThe acft collided with the ground rt wing first after a high sink rate developed in a 45 degree intercept to final with 30 degrees of bank and full flaps. The plt felt the acft sinking and attemtped to stop it with power and reduced angle of bank. He stated…Apr 19, 1986 · N6661Z · Substantial damageNTSB CHI86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Remington, INThe aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed…Apr 19, 1986 · N76460 · Substantial damage