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 ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…NTSB ATL85FA168Accident · No injuriesField investigationFinal reportEmbraer EMB-110-P1 · Atlanta, GAThe acft was on final apch when the circuit breaker caution light illuminated. The PIC failed to verify which cb tripped and assumed it was the gear control cb. PIC then activated emerg hydraulic sys and manually lowered the gear. After landing the hydraulic…NTSB SEA85LA191Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Coalinga, CAThe plt mistakenly landed on a pvt airstrip and during a x-wind landing made a go around due to a gust of wind. The acft struck a dirt berm with the right wing and the right main gear.NTSB SEA85FYM02Accident · Serious injuriesFinal reportRingsdorf-Mcconnell VARI-EZE · Eugene, ORThe acft has a fuselage fuel tank which holds only two gallons as well as two wing fuel tanks. The pilot departed the airport on the fuselage tank and the engine ceased operating before he realized he needed to change the fuel selector. An unsuccessful…NTSB NYC85LA129Accident · No injuriesLimited investigationFinal reportCessna 180J · Hooksett, NHThe plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and…NTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…NTSB NYC85LA127Accident · No injuriesLimited investigationFinal reportCessna C152 · Newry, PAThe student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the…NTSB MKC85FA105Accident · Minor injuriesField investigationFinal reportBeech E-90 · Pine Bluff, ARA simulated eng failure was initiated by the chk airman at 200 AGL. The plt followed the emergency procedures and advanced the pwr levers to bring pwr back to the engine. The plt then noticed the eng failed and had insufficient alt to get an air restart. The…NTSB LAX85FVA02Accident · Serious injuriesFinal reportCessna 172 · Santa Nella, CAWitnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.NTSB DEN85LA139Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Grand Junction, COThe plt reported that as he arrived at the destination (canyonlands, UT), there was a storm over the arpt, so he diverteded toward delta, CO. About 10 mi from delta, he encountered another storm, so he turned toward Grand Junction, CO. Before reaching the…NTSB DEN85LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Plankinton, SDThe acft nosed over after a loss of control during takeoff. The plt was using gravel road for takeoff and rotated prematurely to avoid gravel damage. The acft drifted into tall grass and was then pulled into a ditch and fence posts before nosing over.NTSB CHI85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32T-300 · Milwaukee, WIThe pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.NTSB CHI85LA203Accident · No injuriesLimited investigationFinal reportCessna 140A · Owosso, MIThe plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the…NTSB CHI85LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Michigan City, INShortly after takeoff the acft experienced a total loss of power & made an emerg landing into a corn field. Investigation disclosed that there was no gas in the carburetor. The plt stated that there was about 10 gals in the acft prior to takeoff. No fuel was…NTSB CHI85LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Durand, ILWhile on a night flight the acft experienced a complete loss of engine power. An emergency landing was made to a road. During the landing the right wing of the acft strucka street sign & power pole. The plt stated to the authorities that the acft had…NTSB BFO85LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warrenton, VAThe plt was obtaining transition tng fm pwrd acft to gliders and had flown 3 dual flts n N2885H on the morning of the accident with an instruction on board. The CFI then authorized him to fly his list solo flt and acft tkof obsvd the glider make what he…NTSB ATL85LA167Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAShortly after takeoff with a low fuel state, the plt pulled the acft into a steep climb. A pwr loss was experienced and the acft reportedly stalled and spun into a pond on the pvt grass airstrip. Ten pounds of fuel were drained from the acft after the…NTSB ATL85LA166Accident · No injuriesLimited investigationFinal reportSchweizer SGS-233 · Chester, SCThe instructor pilot cut loose from the tow plane at 200 ft AGL during takeoff to simulate a rope break. The acft collided with trees while circling to land. CFI stated that student plt was too slow in returning to land on the rwy.NTSB SEA85LA119Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Rosa, CAWhile on a short local flight to a costal area and return. The engine lost some power. Carburetor heat was applied but no increase in power was noted. The plt then set up a glide with intentions of making a landing onto the beach area. At about 500 feet…NTSB NYC85FA125Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Latrobe, PADrg an IFR arrival, the acft was vectored for an NDB rwy 23 apch to the westmoreland county arpt. At the NDB final apch fix (8.1 mi from the rwy), the crew turned inbound & contd to the arpt. They contacted the tower & reported over the ILS outer marker (an…NTSB MKC85LA104Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Searcy, ARThe plt reports that the eng lost power during a spray pass and each time he advanced the throttle in an effort to regain power the eng backfired. The plt made a forced landing in a nearby field and the acft hit a ditch, nosed over and burned. The eng was…NTSB FTW85LA226Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Crowell, TXThe pilot landed with a light tail wind on a 3200 ft rwy which slopes downward. The brakes faded and became ineffective due to heavy application. A go-around was attempted; however, flying speed was not obtained and the acft impacted the ground about 200 ft…NTSB DEN85LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Loma, MTThe acft contacted power lines which cross over the Missouri river. The lines are aprx 150-200 ft above the river on one side and aprx 45 ft above the river on the opposite side. The plt stated he was flying along the river at an alt of aprx 75 ft when…NTSB CHI85LA200Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Golden Valley, MNShortly after takeoff, on the last leg on it's flight, the engine of the air cargo acft started to sputter. The plt turned the fuel selector handlr from the left tank to another position & turned on the boost pump. The engine stopped running & the plt elected…NTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…NTSB ATL85FA165Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Milledgeville, GAAcft left home airport at 0400. Flt plan left with FBO indicated 6 hours to destination, no en route stops, and 4+30 hours fuel on board. Fuel consumption calculated, 4+36 hours endurance available. Acft flew 4+47 hours. The pilot told approach control acft…NTSB SEA85LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Couer D'Alene, IDThe eng lost power after carb heat was applied & the throttle was retarded on base leg. Subsequently, the acft nosed over during a forced landing on freshly plowed ground short of the rwy. No preimpact part failure or malfunction was found during the…NTSB SEA85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Rio Vista, CAThe instructor plt (CFI) reported that during a bounced landing recovery, the student plt held the acft in a 3-point attitude above the rwy. As airspeed decayed, the (CFI) took control & added full power. However, the right wing dropped & grazed rising…NTSB NYC85LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moose River, NYThe acft collided with trees during takeoff and crashed. The plt said he encountered turbulence at about 100 ft AGL which' forced' the acft into the trees.NTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…NTSB NYC85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Potsdam, NYThe pilot received a weather breifing and filed an IFR flight plan with massena flight service station. The flight was uneventful and the aircraft was cleared for the NDB approach at Potsdam by boston center. When the airport was in sight, the pilot cnacelled…NTSB MKC85LA103Accident · No injuriesLimited investigationFinal reportAirship Industries Skyship · Columbus, KSIn cruise flt nearing Columbus, Kansas the plt at the controls of the Airship experienced a pitching up of the Airship's nose. The elevator control did not respond to the plt input to counter the nose up pitch. Also noted was a loss of pressure from the rear…NTSB MIA85LA173Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · High Springs, FLThe plt stated that he made a normal takeoff with 2200 RPM, but shortly after rotation, the RPM started to decrease & the acft lost altitude & landed in the top of a large oak tree. An investigation revealed that the carburetor inlet finger screen had a 75%…NTSB MIA85LA172Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Orlando, FLThe plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was…NTSB MIA85FKG02Accident · Serious injuriesFinal reportCessna 150H · Tallahassee, FLThe acft collided with wires during a forced landing off the arpt. The plt had called on the radio saying he was unable to make the arpt and was landing in a clearing. The acft ended up inverted after the collision with the wires. Post accident examination…NTSB LAX85LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Phoenix, AZThe plt had just purchased the acft & this was the first time he had taxied it from the left seat. This plt taxied from the parking ramp up a slight grade an across a taxiway. He reported that when he 'looked up', he observed that the acft was heading toward…NTSB FTW85LRA02Accident · Serious injuriesFinal reportAir Tractor AT301 · Anahuac, TXThe acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt.NTSB FTW85LA228Accident · No injuriesLimited investigationFinal reportCessna 182M · Chickasha, OKThe acft bounced during landing and the student plt allowed the acft to porpoise. The nose gear, engine firewall and propeller were damaged. This was the student's first solo flt. His last 2.7 hrs of dual flt instruction consisted of 18 practice touch and go…NTSB SEA85LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tacoma, WAThe engine ceased operative while on right base for rwy 35 due to fuel exhaustion. The plt ran the left tank dry. The right tank contained full fuel. The plt had been used to flying Cessna's.NTSB SEA85FA110Accident · 1 fatalField investigationFinal reportCessna 402 · Pocatello, IDShortly after departure & level off, the plt reported an eng malfunction & initiated a return to the arpt. About 2 min later, he reported an eng fire & declared an emergency. Aprx 1 min thereafter, the rgt wing separated from the acft & the plane crashed. An…NTSB MKC85LA102Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monticello, ARPlt selected grassy area on arpt for landing. The grassy area was more closely aligned with the surface winds than the available runways. The grassy area has a utility line across the apch end and a ditch on the departure end. The landing was long and hot and…NTSB MIA85LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Jekyll Island, GAThe student plt was on her 1st supervised solo. During a touch-&-go landing, the acft veered off the left side of the rwy & subsequently hit a culvert. The student said that after she landed, she applied too much left rudder.NTSB FTW85LA225Accident · No injuriesLimited investigationFinal reportCessna 150M · Moran, TXThe student plt attempted to make a precautionary landing due to his immediate need to use the bathroom. There were no acft problems involved. The student used 'soft field landing' techniques and touched down on soft ground for an off arpt landing. When the…NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.NTSB ATL85LA164Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe acft drifted right of rwy center line during landing roll & the plt aborted the landing by applying full pwr. The acft continued off the rwy and the nose wheel dug into the soft soil resulting in the acft nosing over.NTSB ANC85FA085Accident · 2 fatalField investigationFinal reportCessna C-207A · Golovin, AKAccording to the pilot-in-command, he was attempting to fly through a mountain saddle. As he turned towards the mountain and began his climb the weather deteriorated rapidly with ceilings zero, visibility zero and severe turbulence. The airplane struck the…NTSB MIA85LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Lakeland, FLDuring takeoff at Lakeland, FL, the left main wheel assembly separated from the acft & struck the leading edge of the horizontal stabilizer, causing substantial damage. The plt did not know the wheel had come off until he was notified by ATC. He then diverted…NTSB MIA85FA170Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · Astatula, FLThe plt (PIC) & his plt rated friend were practicing what the PIC described as simulated crop dusting. After completing a low pass over a field, the PIC made a steep pull up to turn around. He reported that the acft then stalled & crashed. A witness stated…NTSB FTW85FRG01Accident · No injuriesFinal reportCessna 140 · Boerne, TXThe acft cartwheeled after contacting a tree while landing. The plt reported a hard landing occurred, the acft bounced 10 to 20 ft in the air and veered left where it contacted the tree.NTSB CHI85LA197Accident · No injuriesLimited investigationFinal reportHughes 269 · Stonington, ILAfter completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft…