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 DEN89LA027Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COThe private plt was flying 2 friends to his farm. His dirt strip runs east and west, but prevailing winds were 320 deg at 40, gusting to 50 KTS. A cross wind landing to the west had to be aborted and the plt elected to land to the north, on an access road.…NTSB NYC89LA072Accident · Serious injuriesLimited investigationFinal reportBoeing B-747-123 · Bridgetown, BahamasThe failure of the flight attendant to notice that the elevator was not present as she entered the elevator shaft and prior to closing the door.NTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…NTSB MIA89RA122Accident · No injuriesForeign investigationSchweizer 269C · Svarstad, NorwayNTSB LAX89LA033Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Hesperia, CAWitnesses rprtd that the winds at the arpt were out of the west at about 20 KTS with peak gusts of about 37 KTS. They stated the wind sock was indicating a direct x-wind with rwy 3/21 & that the plt initiated his takeoff on rwy 21. Witnesses rprtd that during…NTSB LAX89FA034Accident · 1 fatalField investigationFinal reportBell 47G2 · Phoenix, AZLoss of aircraft control by a unqualified person.NTSB LAX89FA032Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Anaheim, CAFive minutes after departure and during normal cruise flight, the certified flight instructor noticed a prop overspeed. He immediately pulled back on the prop control to reduce engine r.p.m. and instructed the student, a private pilot, to divert to the…NTSB DEN89IA028Incident · No injuriesIncident investigationFinal reportBeech S-35 · Matheson, COThe private plt and a friend were enroute for a hunting trip. Thirty miles east of a refueling stop, the pilot heard a loud knock. Oil covered the windscreen and the engine seized. The plt looked out the side window vent to select a forced landing area. A…NTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…NTSB SEA89FA015Accident · 2 fatalField investigationFinal reportBeech 65 · Elko, NVApprox 10 min after t/o, the pilot stated he was returning to land due to a problem. On final the acft rolled inverted and descended nose down into a residence. Engine exam revealed a failed supercharger intermediate drive shaft gear resulting in loss of…NTSB MIA89MA023Accident · 3 fatalMajor investigationFinal reportRockwell 1121A · Oak Grove, PAFailure of the pilot in command to observe the rapid accretion of ice on the airplane due to his attention being diverted.NTSB LAX89LA031Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Saint Helena, CAThe pilot reported that after completing a three point landing, the airplane began to oscillate. He was unable to maintain directional control. Subsequently, the airplane went off the runway and nosed over in soft dirt. No mechanical failure or malfunction of…NTSB LAX89FA030Accident · 1 fatalField investigationFinal reportCessna 421A · Cabazon, CAThe pilot's poor decision and misjudgement of distance. The separation of the cylinder, failure of the propeller to feather, and impact with wires and a residence were factors in the accident.NTSB FTW89FA012Accident · 1 fatalField investigationFinal reportPiper 601B · Houston, TXPilot's decision to fly the approach visually with outside reference to the lights and inadvertently descending below the decision height off the proper glide path.NTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…NTSB ATL89MA023Accident · 1 fatalMajor investigationFinal reportCessna 210D · Nashville, TNDrg west arr at ngt, plt was vctrd for a VFR, straight-in apch to rwy 2R & adzd of Boeing 727 off his rgt front, passingfm rgt to left. He was cautioned abt wake turbc (w/t) & replied, 'okay I see him.' Ctlr then told plt to turn inbnd & maint 'visual' with…NTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…NTSB MKC89LA018Accident · Serious injuriesLimited investigationFinal reportRockwell S2R · Sublette, KSWhile conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the…NTSB ATL89FA222Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Alexander City, ALOn 10/31/88, the plt obtained wx info & filed an IFR flt plan fm vero beach, FL, to huntsville, AL. At aprx 1513 EST, hectcd ATC & rprtd climbing thru 1500' for 3000'. About 2.4 hrs later, he rprtd a loss of eng pwr. Vectors were provided toward an arpt, but…NTSB MKC89FA017Accident · Serious injuriesField investigationFinal reportCessna T210M · Clarksville, ARThe pilot took off on a 4500 ft runway, raised the landing gear, and turned south at approximately the 2500 ft point. Aircraft lost engine power. Pilot attempted to return to departure runway. Aircraft impacted prior to reaching the runway. Examination of the…NTSB LAX89LA029Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Saint Johns, AZJust after takeoff, the pilot noted cylinder head temp and manifold pressure above red line and a loss of engine power. Mixture had been leaned for tkof. The engine quit when the plt closed the turbocharger wastegate. A forced landing was made upslope on…NTSB LAX89LA028Accident · 1 fatalLimited investigationFinal reportRobinson R22 · Lower Lake, CADuring a local solo instructional flight, the helicopter collided with the terrain in an open field aprx 3 miles from the airport. It was reported to have contacted the ground at considerable downward speed with high rotor RPM. No preimpact mechanical failure…NTSB LAX89DUG01Accident · Serious injuriesFinal reportKlob-Gordon TWIN-STAR · Lake Elsinore, CADuring a pleasure flight, the pilot reduced the engine power to talk to the passenger. When the pilot applied power, the engine did not respond. The airplane was glided to a nearby airport; however, the airplane landed short. The pilot verbally reported there…NTSB FTW89IA011Incident · No injuriesIncident investigationFinal reportBell 206 L-1 · Brownsville, TXUncontained engine failure due to the thermal fatigue of the first stage trubine wheel.NTSB DEN89LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tucumcari, NMThe private plt was flying a friend over his ranch searching for cows. The plt reported making a 40 deg left banked turn at 300 ft AGL at full power and 70 knots. He said that the plane would not respond to aileron control inputs initially. The plt said the…NTSB DEN89DTE02Accident · 1 fatalFinal reportJones Christen Eagle II · Parker, COThe plt was performing aerobatics in a homebuilt christen eagle near his girlfriend's house where a birthday party was in progress. Witnesses said the acft executed a roll at low altitude and 'went straight in.' Weather was not a factor and examination of the…NTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…NTSB ATL89FA020Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Memphis, TNThe acft was being taxied to the gate when its right wingtip struck a catering truck that had been driven off of the designated driving lanes & partially onto the taxiway. The flt crew rprtd that the truck was traveling in the same direction within the…NTSB ANC89LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot reported that he lost directional control of the airplane during a post-flight taxi to tie down. He said that a small flashlight had fallen behind the left rudder pedal and limited the amount of brake and rudder available for directional control.NTSB MIA89LA021Accident · No injuriesLimited investigationFinal reportCessna 182J · Okeechobee, FLThe plt rprtd that while landing at night, the acft bounced twice. Subsequently, it went off the rwy & onto a grass area. During the occurrence, the nose gear collapsed.NTSB MIA89LA020Accident · Minor injuriesLimited investigationFinal reportParsons B-8M · Lake City, FLDuring an airshow, the plt took off to perform a planned 8-spin autorotative landing from an alt of aprx 800 ft. an FAA inspector who observed the accident stated the flt ascended to aprx 650 ft MSL. After closing the throttle, the plt began the maneuver.…NTSB MIA89LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot noted an explosion in the right wing during engine start. He stated that the aircraft had been 'topped off' prior to the flight. Residue of fuel was found in the wing outside the fuel cells after the explosion.NTSB LAX89LA027Accident · 1 fatalLimited investigationFinal reportLet L-13 · Marana, CAThe pilot reported that shortly after liftoff from runway 26 the control stick became difficult to move. He decided to continue the air tow and release at 200 feet AGL after release, the pilot turned the glider to return to the runway to land. He was still…NTSB DEN89FA024Accident · Minor injuriesField investigationFinal reportCanadair CL-600-1A11 · Aspen, COThe pic's failure to follow approved procedures and directives; the pic's failure to attain/maintain direction control of the airplane, the pic's failure to abort the takeoff in a timely manner; and the pic's failure to follow proper aborted takeoff…NTSB CHI89LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Columbus, OHStudent pilot's failure to maintain control of the airplane during landing flare.NTSB BFO89LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cambridge, MDThe stu plt did three takeoffs & lndgs with the instr aboard and then three more during solo flight. On his fourth takeoff try he used aileron and rudder to maintain directional control on the rwy. There was an 8 to 10 kt crosswind. The stu said when the acft…NTSB BFO89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dover, DEAfter takeoff the plt began a cruise climb to 5500 ft. he rprtd that when the acft reached 5200 ft, he noticed oil spraying from underneath the front of the eng cowling. The oil eventually covered the windscreen. The plt diverted toward a nearby arpt, but the…NTSB BFO89FA004Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Ocean City, MDThe pilot failed to maintain adequate clearance above the terrain. Contributing factors are inattention to altitude and dark night conditions over illusionary producing featureless water.NTSB ATL89LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazel Green, ALThe flight instructor and the pre-solo student crashed after takeoff about 1/2 mile from the Hazel Green airport. The acft had been operated about one hour since the original takeoff from huntsville, Alabama. The instructor pilot reported that about 12…NTSB ATL89FA019Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Austell, GAPIC was obtaining bfr; stalls & flt at min control airspeed were completed. PIC began descent from 2500 MSL to his pvt strip for simulated engine out landing. In a subsequent interview PIC said carb heat was applied & removed after 30 sec. In his rpt he said…NTSB MIA89LA018Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Arcadia, FLAfter making an apch to 'the numbers' on rwy 5, the plt decelerated the helicopter & began to air taxi to the refueling area. Subsquently, while decelerating and/or while taxiing, the tail rotor collided with terrain.NTSB MIA89LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, MSDuring normal cruise flt a portion of one propeller blade separated. The plt landed the acft in a field & during the landing roll, the acft collided with a haystack. Examination of the propeller blade revealed it separated at blade station 28.5. Metallurgical…NTSB LAX89LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · San Carlos, CADuring a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5…NTSB LAX89FA025Accident · 2 fatalField investigationFinal reportPiper PA31P-350 · Redlands, CAThe pilot's inadvertent selection of an inappropriate altitude for the attempted night special VFR circle to land maneuver. Contributing to the accident was the dark night, restricted visibilities and lack of ground reference lights. Also contributing to the…NTSB FTW89LA010Accident · No injuriesLimited investigationFinal reportHughes 269C · Dickens, TXThe pilot was inspecting a herd of cattle when he thought the helicopter was developing a problem with the engine and main rotor. He started an autorotation, lost tail rotor control, and went into a left spin which continued to contact with the ground.…NTSB DEN89LA021Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Fort Peck, MTThe plt enctrd hvy snow at night & turned back to find a nearby landing strip that he was familiar with. He recognized a ranch house associated with the strip, but was unable to find the landing area. He began to circle in hopes that someone would turn on the…NTSB NYC89LA019Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Norwood, MAThe pilot had just climbed to 2500 feet when the right engine started to sputter. When he placed the fuel selector in crossfeed, both engines quit. The pilot elected to land in a field leading to substantial damage to the nose, wings, and tail section of the…NTSB MKC89LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Davenport, IAWhile demonstrating an autorotation touchdown, a tailboom strike was experienced. Damage was incurred to the tailboom, the tail rotor drive shaft, and one main rotor blade. The CFI said everthing felt normal during touchdown and believed the soft terrain…NTSB FTW89LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskogee, OKAcft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the…NTSB ATL89LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe student plt reported that the airplane nose '...was wanting to come up sooner than it should' during the takeoff roll on his first solo flt; he checked the elevator trim and found it properly set. He elected to abort the takeoff. He reduced the pwr and…