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 SEA86LA076Accident · No injuriesLimited investigationFinal reportBeech 18 · Seattle, WAThe pilot lost control of the aircraft on takeoff and a subsequent groundloop occurred. Although the pilot has a DC-3 type rating, he had only 20 hours in this aircraft.NTSB SEA86FA075Accident · Serious injuriesField investigationFinal reportStinson 108-2 · La Conner, WAPlt was on approach for water landing in a canal used during previous summer for floatplane ops at dusk. Plt was looking for a specific boat moored in canal as landing mark, extended approach path beyond normal touchdown point. Acft struck telephone cable…NTSB FTW86FRG17Accident · Minor injuriesFinal reportCessna T210 · Ozona, TXThe acft was damaged in an off-arpt lndg after the eng quit. The plt said there was plenty of fuel on board the acft which was being ferried to its owner after an eng change. The plt was unable to restart the eng which had vibrated so that the plt thought he…NTSB FTW86FRD10Accident · Minor injuriesFinal reportPiper PA-28-140 · Krotz Springs, LAThe acft crashed into a road sign during a forced landing on a hiway following fuel exhaustion. The plt had made a x-country flt and only added ten gals of fuel for the return trip. His estimate of fuel remaining was inaccurate partly because the carburetor…NTSB DEN86FA098Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truth&Consequen, NMThe plt took off on a night IFR flt after being briefed on adverse wx which included severe turbulence and moderate mixed icing conditions. The acft was not equipped for flt in icing conditions. Radio and radar contact with the flt was lost in the vicinity of…NTSB BFO86LA019Accident · No injuriesLimited investigationFinal reportCessna 150M · Orange, VAAt about 1245 EST, the plt took off on his second flt of the day and flew in the local area about 30 minutes. Upon returning to Orange county arpt, the plt observed the tetrahedron during the left downwind leg for rwy 25, and noted that the wind had changed…NTSB ATL86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hanceville, ALWhile enroute to birmingham the pilot experienced a complete power failure when no. 2 cylinder separated from the engine assembly. The pilot attempted to make an emergency landing on interstate 65 near Hanceville, AL, and the aircraftcollided with an…NTSB ATL86FMG05Accident · No injuriesFinal reportCessna 150 · Yadkinville, NCThe acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail.NTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.NTSB MKC86LA067Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Jacksonville, ARThe pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As…NTSB LAX86LA137Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Roll, AZThe plt landed at gila bend municipal arpt for fuel. The refueling facilities were closed and the decision was made to proceed to yuma int'l arpt, about 113 miles east of gila bend arpt. The plt had flown the acft for about 4 hrs and 5 minutes prior to…NTSB DEN86LA097Accident · No injuriesLimited investigationFinal reportMooney M20F · Longmont, COAccording to the plt, during the flare to touchdown, the acft stalled and the left wing contacted the ground along with four runway lights. The plt said the accident could have been prevented by maintaining a higher airspeed on apch.NTSB BFO86FID04Accident · No injuriesFinal reportCessna 210N · Blacksburg, VAWhile landing at Blacksburg airport in Blacksburg, Virginia, the landing gear failed to extend. The aircraft collided with a runway light and served off the runway onto a grass area causing substantial damage to the left stabilizer and elevator. The pilot…NTSB ANC86LA034Accident · No injuriesLimited investigationFinal reportBell 206B3 · Livengood, AKHelicopter experienced power loss while flying low level pipeline patrol, resulting in a hard landing and substantial damage to the acft. The governing pressure (pg) air line fitting was found loose on the power turbine fuel governor.NTSB ANC86IA033Incident · No injuriesIncident investigationFinal reportCessna 207 · Barrow, AKEngine failed and seized in flight. A forced landing and the snow covered tundra followed with no injuries & minor damage to the airplane. Engine teardown and exam revealed #3 cylinder wrist pin broken.NTSB MKC86LA066Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Versailles, MOThe plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt…NTSB MIA86LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Captiva, FLThe plt stated that she was making a low final approach to the 2200 ft grass strip & lost lift as the acft passed below & behind the treeline. The plt's husband, also a plt, occupying the right front seat, stated that his wife may have been somewhat…NTSB LAX86LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Guinda, CAThe plt & his roommate went flying in a rented acft. The plt maneuvered the acft through a valley, reversed course, descended over an assembly of persons & while buzzing them collided with trees. The plt was able to fly the substantially damaged acft back to…NTSB FTW86LRD09Accident · No injuriesFinal reportPiper PA-22-150 · Sulphur, LAOn March 9, 1986, at 0900 CST, Piper aircraft PA22-150, N3821P, registered to derrick d. smith, experienced a power failure due to fuel exhaustion. This was a pleasure flight in visual meteorological conditions. No flight plan was filed. The aircraft was…NTSB DEN86LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Ft. Bridger, WYAccording to the plt, he and his passenger were ferrying an acft back to the point of origin after a sar mission for the civil air patrol, when they encountered IMC weather. The plt stated he was making a precautionary landing on a dirt road when the acft…NTSB DEN86LA095Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P Aerostar · Dickinson, NDWhile enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an…NTSB CHI86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Carmel, INThe student plt was on a x-country flt. He took off from an en route arpt with aprx 12 gal of fuel on board & was returning to his home base. Due to high winds at the destination arpt, the student diverted to an alternate arpt. While en route, the acft ran…NTSB BFO86FA018Accident · Serious injuriesField investigationFinal reportHughes 500D · Mt. Crawford, VAAfter refueling at shenandoah valley airport located near staunton, Virginia, the helicopter climbed to about 1800 feet MSL on a north heading. Approximately 15 minutes after departure a loud rumble was heard coming from the rear of the aircraft and the pilot…NTSB ATL86LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post.NTSB MKC86FCA02Accident · Serious injuriesFinal reportCessna A152 · Old Monroe, MOThe stu PIC and his instructor were practicing forced lndgs to a corn stubblefield. As they initiated a climb fm a simulated forced lndg, the acft crashed nose low, right wing low. No mech pblm was found with the flt controls or the pwrplant.NTSB MIA86FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kissimmee, FLThe flt departed with 18 gals in each fuel tank. After 1.8 hrs of flying, doing takeoffs and landings and a short flt to another arpt, the flt experienced an eng failure during takeoff from a touch and go landing. The plt failed to maintain directional…NTSB LAX86FVD06Accident · Minor injuriesFinal reportCallair A-9B · Lodi, CAPilot was returning to Lodi airport after aerial application when the engine lost oil pressure. The engine seized, and a forced landing was made in a vineyard.NTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…NTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.NTSB SEA86FA073Accident · 1 fatalField investigationFinal reportAerospatiale SE 318C · Siletz, ORThe plt unsuccessfully attempted to lift a 1597 lb load of cedar blocks which would have placed the helicopter aprx 880 lbs over its max gross weight with an external load. The plt was setting the load down for ground personnel to unload some of the blocks…NTSB MIA86LA092Accident · No injuriesLimited investigationFinal reportCessna 210J · Jacksonville, FLThe plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed.NTSB LAX86LA136Accident · No injuriesLimited investigationFinal reportCessna 177B · Tehachapi, CAAfter determining the takeoff wt of the acft would be over the max gross, the plt asked the operator the day before the accident to drain 20 gals of fuel from the tanks.a plt who flew the acft prior to the accident flt said he flew for about one hour and did…NTSB LAX86FVA03Accident · Minor injuriesFinal reportSchweizer G164A · Wasco, CAThe acft went off the left side of rwy during a downwind landing. The ag plts made a practice of landing downwind to speed up turn-around time. They relied on their brakes to maintain control. The acc acfts brake pads were worn and the rt brake was fluid…NTSB FTW86LA041Accident · Minor injuriesLimited investigationFinal reportHughes 369D · New Boston, TXThe pilot experienced a tail rotor drive shaft flexible coupling failure when he pulled collective pitch to come to a hover before landing. The helicopter entered an uncontrollable right spin. During his haste to get the helicopter on the ground the pilot…NTSB FTW86FPA21Accident · Minor injuriesFinal reportCessna 150K · Cresson, TXThe flt departed with an estimated 8 to 9 gallons of fuel (auto gas) on board with a dual student and a flt instructor. Forty five minutes of touch-and-go landing practice was accomplished. On the sixth takeoff and about 30 feet above the ground the engine…NTSB DEN86LA093Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bountiful, UTAcccording to the student plt, touch and go landings were being practiced when the acft stalled on takeoff. Witnesses stated the plt lowered the nose in an attempt to recover from the stall, however, the acft contacted the rwy.NTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…NTSB LAX86FVD07Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot was making a slow pass and dragged one spray boom on the ground. Insufficient airspeed resulted in loss of control. Helicopter crashed.NTSB DEN86FA092Accident · 3 fatalField investigationFinal reportCessna 177 · Anaconda, MTThe sole surviving pax said the eng lost power during cruise flight over mountainous terrain. The plt attempted a forced landing but hit a tree and the acft crashed. Aprx 5 gals of automotive fuel were drained from wing tank. Fuel sample taken from plt's…NTSB ATL86LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Fayetteville, NCDuring landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition.NTSB LAX86LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Toro, CAA helicopter crashed into a mountain slope east of El Toro, CA while on a business flt. While the acft approached the mountain peak the plt experienced an increase in the rate of descent and aborted the landing. During the go-around, at adecreased main rotor…NTSB LAX86LA134Accident · No injuriesLimited investigationFinal reportBurkhart Grob 102 · Tehachapi, CAGrob 102 glider collided with trees 6 mi s of the apt. The plt was soaring 2 mi s of the apt at 5900 ft MSL and 6200 ft MSL in 'weak lift.' He elected to fly further s in the vic of a ridgeline with an elev approx 6000 ft MSL. Again the plt experienced 'weak…NTSB FTW86FRG16Accident · Minor injuriesFinal reportCessna U206F · Mcallen, TXOn 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft…NTSB CHI86FA098Accident · 5 fatalField investigationFinal reportMitsubishi MU-2B-60 · Eola, ILEvidence shows co-pilot called, 'mayday, uncontrolled spin' after acft radar track showed decel from 180 to 120 KTS over 2 min period while maintaining constant 4000 ft crz alt. Constant alt consistent with autopilot/autotrim use, particularly in view of…NTSB SEA86FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Tenino, WAThe non-instrument rated pilot departed for his destination without filing a flight plan nor obtaining a weather briefing. The flight was conducted in dark night and instrument meteorological conditions. Low ceilings prevailed in the vicinity of the accident.…NTSB MIA86LA090Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLThe plt stated that just after picking up a banner, the acft stalled and started to roll to the left. The plt was unable to recover before the acft impacted the ground.NTSB LAX86LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · San Luis Obispo, CAOn March 4, 1986 a Cessna 152 collided with the runway surface after the nose wheel collapsed. The student pilot was on his third consecutive solo flight since his solo endorsement. On his third approach the aircraft bounced on landing and became airborne…NTSB DEN86FTI01Accident · Minor injuriesFinal reportMiller Sievers Special · Gillette, WYOn March 3, 1986 at approximately 1715 MST, an experimental Miller, sievers special, struck the ground during takeoff at the Gillette-campbell county airport, Gillette, Wyoming. The pilot stated that just after takeoff on runway 34, the aircraft appeared to…NTSB CHI86FA096Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Honolulu, HIThe scheduled passenger flight from Honolulu to chicago encountered clear air turbulence (cat) about 500 NM east of Honolulu while in cruise flight at flight level 330. The turbulence was unexpected, had not been forecast, and the fasten seat belt was not…NTSB ATL86FA085Accident · No injuriesField investigationFinal reportBeech BE-90 · Mount Pleasant, TNOn final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal…