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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…