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 FTW84LA397Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Flatonia, TXThe plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake.NTSB FTW84IA400Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Dfw Airport, TXThe acft experienced sepn of the rgt wing #3 leading edge slat while descending for an apch. An investigation revealed that on 7/5/84, the company performed a 'c' check inspection of the acft. At this time a rgt wing #3 leading edge slat retract aluminum…NTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…NTSB CHI84LA391Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Medina, OHAcft had been fueled for aprx 4 hrs endurance. Two hrs into flt on IFR flt plan, plt descended to 3000 ft with intermittent visual ground contact. Shortly thereafter, with the acft about 10 mins from destination, the engine began to sputter. Plt stated he…NTSB ATL84LA289Accident · No injuriesLimited investigationFinal reportWilliam T. Hodges Goldwing · Americus, GADuring the initial takeoff climb at an alt of 150 ft AGL, a ttl loss of power occurred. A forced landing was made in a soybean filed at which time the acft was substantially damaged. The plt stated the loss of power resulted from the installation of a…NTSB ANC84LA183Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKWhile taxiing for takeoff the aircraft's left wing struck a duck shack.NTSB ANC84LA174Accident · Minor injuriesLimited investigationFinal reportCessna T-207 · Daniels Creek, AKPilot stated that after landing 100 feet past the runway threshold, the aircraft appeared not to be stopping when brakes were applied. A go-around was initiated, but the aircraft failed to get airborne and ran off the departure end ofthe strip colliding with…NTSB ANC84FA176Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKPlt stated takeoff was slow and acft could not clear on-coming rising terrain and obstacles. Left wing contacted 100 ft tall tree tops aprx 2500 ft from departure end of rwy yawing acft 180 degrees from direction of flt. Plt failed to perform weight and…NTSB SEA84FA228Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Burley, IDWhile climbing after takeoff, the eng surged twice, then quit. The plt repositioned the fuel selector, checked that the electric fuel pump was 'on' & restarted the eng, then started to return to the departure arpt. However, about 1 min later, the eng lost…NTSB LAX84LA480Accident · No injuriesLimited investigationFinal reportFocke-Wulf 44J Stieglitz · Hollister, CAThe two commercial rated pilots were flying together for the purpose of gaining proficiency so that one of the plt's could pass his bfr. The one plt who was not current performed tree takeoffs and landings from the front seat. The plts then switched seats and…NTSB LAX84LA479Accident · No injuriesLimited investigationFinal reportCessna 150M · Baker, CAThe acft was damaged in a forced landing after the engine quit. The acft made a stop during its x-country and fuel was added which did not fill the tanks. During the next days flt the plt noticed the fule gages indicated almost empty and headed for the arpt…NTSB LAX84FU034Accident · 1 fatalFinal reportMitchell A-10 · Corning, CAThe ultralight had recently been purchased by the new owner who received no instruction in its operation. On the day of the accident, he told his wife he was just going to taxi-test the vehicle. She said there was no intent to fly. When sheno longer heard or…NTSB FTW84LA396Accident · No injuriesLimited investigationFinal reportCessna 152 · Laporte, TXDuring the ldg flare the acft drifted left and touched down near the edge of the rwy. The plt did not correct the drift and the acft drifted off the left side of the rwy. After colliding with a ditch the acft nosed over coming to rest inverted.NTSB FTW84LA395Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mandeville, LAThe acft made an emerg landing on the south lanes of the lake pontchatrane causeway bridge after encountering a loss of eng power. Examination of the acft fuel tanks revealed both tanks empty. Activation of the fuel tank drain valves & the fuel strainer…NTSB FTW84LA394Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Spicewood, TXDespite the existence of an airstrip across the street from his home, the plt elected to takeoff & land on the street. During the landing, the acft hit several trees & a pump house. Local law enforcement officers reported that the plt was drunk and drinking…NTSB FTW84FA393Accident · Serious injuriesField investigationFinal reportBell 206B II · Dallas, TXAcft made forced autorotative landing off arpt in a residential area which was congested. Acft developed a high sink rate in the autorotation and landed hard. The forced landing was due to fuel exhaustion. 45 gallons of fuel were added to the acft at 1226 CST…NTSB ATL84FA286Accident · 1 fatalField investigationFinal reportPiper 602P · Dayton, TNOn arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen…NTSB SEA84LA227Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kasaan Penninsu, AKPlt attempted takeoff from glassy water with a deer tied to the left float. The right float would not come up on the step to attain lift off. The pilot's decision to abort was too late to avoid a collision with rocks at the end of the lake.NTSB NYC84LA311Accident · No injuriesLimited investigationFinal reportCessna 172P · White Plaines, NYThe solo student plt stated that she was up set by a request from the tower to do a 360 deg turn on downwind and another acft in the pattern transmitting that the turn would put the 2 acft on a collision course. The turn was not completed and the plt…NTSB NYC84FFJ05Accident · Minor injuriesFinal reportHomebuilt DER Jager DIX · Albion, NYThe plt reported that after takeoff he did normal flt maneuvers, slow flt, stalls & wing overs in the Homebuilt acft. He then decided to do a barrel roll, which he described as smooth until completion when the acft wanted to continue in the roll & the nose…NTSB MKC84LA277Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Vilonia, ARThe acft was forced to land after takeoff when the engine lost power. The plt said he had refueled from the automotive pump at his grocery store. The plt suspected water contaminaion in the fuel.NTSB MIA84LA252Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T15 · Climax, GAThe plt said he was familiar with the area and was aware of the power line but misjudged his clearance and inadvertantlycollided with the top wire. The wire broke and wrapped around the landing gear of the acft and dragged it down. The acftwas destroyed when…NTSB FTW84LA392Accident · No injuriesLimited investigationFinal reportCessna 140 · Liverpool, TXAt aprx 900 ft AGL the eng lost power and the plt executed a forced landing in the unimproved terrain. At touchdown the acft struck trees and a dirt enbankment nosing over inverted. Investigation revealed water in the gascolator as well as the left fuel tank.…NTSB FTW84LA391Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Ship Shoal 241The pilot had landed on a offshore helideck, which had one aircraft parked on it. After the passengers were clear of the aircraft, the pilot picked the aircraft up to a hover. During the hover, the pilot allowed the aircraft to drift slightly and one skid…NTSB DEN84FA290Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Denver, COPlt had slowed the helicopter to 30 KIAS using 50 to 60% pwr at an alt of 700 ft AGL. Plt the heard 'two beeps' from the eng out warning horn, saw eng out annunciator lights illuminate & the 'turbine neddle dropping.' Plt 'bottomed'the collective, lowering…NTSB ANC84LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Tasnuna Valley, AKThe plt stated that they had just taken off from a gravel bar when they spotted a moose. He circled the moose in a left orbit at about 65 miles per hour. During one of the orbits the 'right wing fell in a downward direction and the nose of the acft pitched…NTSB SEA84LA226Accident · No injuriesLimited investigationFinal reportMaule M6 · Driggs, IDAfter landing long and fast brakes were applied, directional control was lost and the acft ground looped off of the rwy. The acft collided with and came to rest in a ditch.NTSB MKC84LA275Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Little Rock, ARThe antique acft was purchased and a ferry flt to California attempted with very limited dual instruction and minimal knowledge of the acft. The propeller installed on the acft was not in accordance with FAA specifications. An STC was available for the…NTSB LAX84LA478Accident · No injuriesLimited investigationFinal reportAgusta A109 · Clifton, AZThe plt reported that he landed firmly on the ground at the main ramp & went into the 2 min cool down mode for eng shutdown. He stated that immediately after the power levers were retarded to idle, he felt a slight lateral movement of the controls which was…NTSB FTW84LA415Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe plt stated he was following an aerial application acft & may have encountered propeller wash/downdraft. The acft collided with the ground & was substantially damaged.NTSB FTW84LA390Accident · No injuriesLimited investigationFinal reportFairchild M-62A (PT-19) · Melville, LAThe student plt stated that the acft touched down long and bounced. He applied power to go-around and lost directional control colliding with a fence on the left side of the rwy. The wind was clam.NTSB DEN84LA288Accident · Minor injuriesLimited investigationFinal reportBell 206B · Vernal, UTPlt stated that while on a heading of 050 degs (wind from 270 degs at 5 KTS) the acft began to shudder and veered to the right. Plt attempted remedial action but acft continued descending in a right spiral to ground contact. Examination of the helicopter did…NTSB NYC84LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDDue to a left drifting tendency the solo student plt aborted the first landing. On touchdown for the second apch, the acft again veered left and continued off of the rwy colliding with a ditch. There were no mechanical malfunctons reported or discovered.NTSB NYC84FA310Accident · 2 fatalField investigationFinal reportAeronca 11AC · Newbury, MAThe student plt had logged approximately 240 hrs of flying time. He was not certificated to carry pax. Witnesses stated that they observed the acft descend at a slow airspeed to an alt of 100 ft. the acft then made a steep bank turn to the right and impacted…NTSB MKC84LA276Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Cedar Rapids, IAThe Balloon landed in a field and as wind drifted it, the envelope draped over a pwr line. The plt said his burner malfunctioned and caused the inaccurate landing. Another account was told later in which the plt switched to an empty propane tank for landing.…NTSB MKC84LA274Accident · No injuriesLimited investigationFinal reportGates Learjet LR-24D · Chesterfield, MOThe acft was landed in a thunderstorm with a 16 kt left quartering tailwind. The plt was aware of an area on the rwy which tended to collect water but due to heavy precipitation this area could not be viewed from the cockpit. The left main gear hydroplaned as…NTSB FTW84LA388Accident · No injuriesLimited investigationFinal reportCessna T210M · Austin, TXDuring arrival, the plt reduced power on base leg for for a landing. When he realized his airspeed was dissipating faster than normal, he advanced the throttle, but the eng did not respond. The plt then switched fuel tanks, turned on the boost pump & applied…NTSB FTW84LA387Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wharton, TXAfter landing on rwy 14 the plt did a 180 deg turn and taxied back down the rwy. While attempting to turn right onto the taxiway the left main gear departing the improved surface and collapsed when it struck a concrete culvert. Brake skid marks were found on…NTSB FTW84LA386Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Altus, OKAccording to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before…NTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…NTSB DEN84LA287Accident · No injuriesLimited investigationFinal reportCessna 140 · Belgrade, MTThe plt stated that during the takeoff ground roll on the grass airstrip the engine did not seem to produce full power when 2/3 the way down the rwy. Plt applied brakes to abort the takeoff before the tailwheel was on the ground. The acft nosed over.NTSB CHI84LA390Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Westfield, INThe acft collided with a powerline during landing. The plt said he 'found himself too low and gunned the engine to stay over the corn field but did not see the wires. Had never known they were there.'NTSB ANC84LA172Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Big Lake, AKAccording to the plt, he was taking off from a lake when he decided that he did not have sufficient room to clear trees in his flt path. He aborted the takeoff & the acft settled onto a gravel berm & slid into tundra. The plt believed that the accident would…NTSB SEA84LA225Accident · No injuriesLimited investigationFinal reportCessna 150 · Bandon, ORThe plt indicated that 15 minutes had been flown on the full fuel tank prior to the accident flight. The plt departed at 1330 on a siteseeing flt around the local area. After 3.7 hrs of flight, while on final approach to rwy 34, the engine quit. The plt…NTSB NYC84FIG04Accident · 1 fatalFinal reportJett Shoestring · Gaithersburg, MDAccording to witnesses, the acft experienced an engine power loss during the initial climb after takeoff. The acft was observed to descend near vertically to ground impact. Teardown of the engine revealed discrepancies in the carburetor assembly. The plt had…NTSB CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.NTSB ANC84LA180Accident · No injuriesLimited investigationFinal reportCessna U206 · Hartman River, AKThe pilot stated that after takeoff the right gear collided with brush slowing the aircraft. The aircraft then touched down in rough terrain and nosed over.NTSB SEA84LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Deeth, NVWhen the aircraft descended below tree top height on final approach, the headwind vector was lost and the aircraft settled to a hard landing. During bounce recovery, the pilot added power but raised the flaps. The aircraft stalled and impacted the ground nose…NTSB NYC84LA278Accident · No injuriesLimited investigationFinal reportCessna C182 · Norridgewock, MEA parachte became entangled in the horizontal stabilizer while the acft was maneuvering to drop the parachutists. The acft made a hard landing after the parachustist disengaged from the acft. The acft stabilizer spar was damaged in the encounter and the lack…NTSB MKC84LA273Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Pleasant Hill, MOThe acft settled into 10-15 ft tall trees during takeoff. The rwy was 1200 ft long and the wind was 2 KTS. The plt said the trees should be cut as a preventive measure. The plt also said there were no problems with the acft.