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 ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB SEA88IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Portland, ORCrew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.NTSB DEN88GA088Accident · No injuriesFinal reportBell 47G-3B1 · Gobernador, NMThe commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and…NTSB BFO88LA027Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVAccording to the student plt, the acft crabbed to the left just prior to touchdown. Upon touchdown, the acft veered left and traveled off the rwy into muddy grass. Despite the plt's use of brakes and right rudder the acft continued down an embankment where it…NTSB SEA88LA066Accident · No injuriesLimited investigationFinal reportCessna 150 · Fox, ORWhile departing an airstrip situated on top of a hill the aircraft was not able to clear power lines at the end of the airstrip. The pilot lowered the nose of the aircraft to clear the wires and the aircraft's elevator struck a road sign in flight. The…NTSB SEA88LA064Accident · Serious injuriesLimited investigationFinal reportMarlow Hilyard Executive · Elko, NVThe pilot made a landing on sloping terrain. The gyrocopter rolled to the left with the main rotor striking sage brush. The engine was twisted from its mounts rupturing a fuel line. A fire resulted consuming the gyrocopter. The pilot did not hold a pilot or…NTSB NYC88LA111Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Rutland, VTPrior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began…NTSB NYC88LA110Accident · No injuriesLimited investigationFinal reportCessna 182RG · Princeton, NJDuring landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again…NTSB MKC88LA066Accident · No injuriesLimited investigationFinal reportBeech 23 · Fulton, MOWhile attempting a crosswind landing, the acft began to porpoise and veered off the runway. The left ldg gear failed and the wheel struck the aft section of the fuselage, then the horizontal stabilator. The PIC then applied full power, became airborne and…NTSB MKC88LA064Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Manter, KSWhile conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the…NTSB CHI88LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Sebewaing, MIThe plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed…NTSB BFO88FA026Accident · 3 fatalField investigationFinal reportCessna 210N · Quantico, VAThe acft was abt 25 mi south & inbound to dca when the plt rprtd an enctr with snowshwrs which were part of a cold front. He asked & was clrd to dscnd to 2500 ft so he could maint VMC. Radar data showed, the acft dscndd past 2500 ft to 1300 ft. abt 16 mi…NTSB ATL88LA122Accident · No injuriesLimited investigationFinal reportCessna 310Q · Donalsonville, GAThe pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued…NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…NTSB ATL88LA120Accident · Serious injuriesLimited investigationFinal reportSlingsby Dart T-51 · Whitwell, TNThe glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull…NTSB SEA88LA063Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cashmere, WAThe acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over.NTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…NTSB SEA88LA061Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Blackfoot, IDThe pilot lost directional control of the aircraft during gusting crosswinds. During landing rollout the aircraft veered from the centerline of the runway to the right striking a fence. The pilot had only 7 hours of flight time in this aircraft.NTSB SEA88FA060Accident · Serious injuriesField investigationFinal reportPitts S-1C · Carson City, NVUpon returning to the Carson airport, N3545 (nieuport) approached from the south and executed a 45 degree entry to the downwind leg for runway 27. While established on final and approximately 100 feet from the threshold to runway 27, and at an elevation of…NTSB NYC88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737 · Morristown, NJBoeing 737 (N69348) was depg newark intl arpt as a lear jet 24 (N500NH) was depg fm teterboro. Both were being ctld by new york TRACON (newark sector). The strip for the 737 was mismarked as a north departure rather than an east departure. The instructor/full…NTSB MKC88LA065Accident · No injuriesLimited investigationFinal reportCessna 150J · Searcy, ARWhile landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control.NTSB LAX88LA131Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Phelan, CANTSB FTW88LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Weatherford, TXA forced landing was attempted following a complete eng failure. The plt overshot the intended touchdown pt and pulled the acft off the grnd in an attempt to clear a busy hwy. however, the acft struck wires located next to the road. Evidence indicated that…NTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…NTSB SEA88LA059Accident · No injuriesLimited investigationFinal reportBeech A24R · Las Vegas, NVDuring climb to cruise the aircraft's door opened. The pilot then diverted to a nearby airport for a precautionary landing. During landing the pilot had difficulty maintaining directional control. The aircraft struck a runway edge light during landing roll…NTSB LAX88LA136Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIAfter touchdown the plt reduced the throttle and removed his left hand from the throttle/collective pitch control to retune the radio. His attention was directed to the frequency indicator during the procedure. The helicopter became airborne and moved to the…NTSB CHI88FA079Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Taylorville, ILThe helicopter experienced a loss of control while in slow flight out of ground effect. The helicopter impacted the ground in a black plowed field during a period of low visibility due to snow. The occurrence happened in a remote area with few ground…NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…NTSB SEA88LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gold Bar, WAThe instructor pilot and his dual student flew into a canyon area. The aircraft was allowed to fly too close to rising terrain which the aircraft was unable to outclimb. During a turn to reverse direction the aircraft collided with terrain. The CFI stated…NTSB LAX88FA130Accident · Serious injuriesField investigationFinal reportDornier DO-24 · Oildale, CAPilot's improper fuel consumption calculations and his failure to properly use the mixture control.NTSB LAX88FA129Accident · 1 fatalField investigationFinal reportBeech V35B · Oildale, CAImproper maintenance given by the fixed based operator.NTSB DEN88IA083Incident · No injuriesIncident investigationFinal reportCessna 210 · Billings, MTNTSB ATL88FA118Accident · 2 fatalField investigationFinal reportChampion 7BCM · Bishopville, SCThe student pilot, carrying a passenger, attempted a low level maneuver, and stalled the aircraft. He was unable to recover in the altitude available and the aircraft struck the ground. Toxicological tests on the blood/urine were done on the PIC. The blood…NTSB ATL88DMG04Accident · Minor injuriesFinal reportMarrek Smyth Sidewinder · Honea Path, SCNTSB ANC88LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · Tok, AKThe private pilot attempted to take-off at dusk with a left main gear wheel brake that was frozen in the 'on' position. He had unsuccessfully attempted to free the brake prior to TAKE0FF, but felt that he could get the airplane airborne by skidding the tire…NTSB CHI88DEX03Accident · Minor injuriesFinal reportPiper PA-28-140 · Evansville, INPilot attempted maximum gross weight take-off from soft soggy field with 10 degree flaps selected. Stall warning activated on lift-off, aircraft climbed to approximately 50 feet then began losing altitude and airspeed, made uncontrolled landing in muddy field…NTSB ATL88LA116Accident · No injuriesLimited investigationFinal reportCessna 172F · Myrtle Beach, SCThe pilot reported that the airplane began to sink rapidly about 100 ft above the rwy threshold. He added pwr and initiated a flare. Upon touchdown, the airplane pitched down and rolled rt. The airplane subseqeuntly skidded off of the rt side of the rwy and…NTSB MKC88LA063Accident · No injuriesLimited investigationFinal reportBeech C23 · Sullivan, MOWhen the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he…NTSB MKC88LA062Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Point, ARThe pilot said, shortly after takeoff, enroute to an aerial application operation, the engine began to lose pwr and began backfiring. He dumped a portion of his load, and made an emergency ldg in a soft, unplanted bean field. After rolling about 200 feet, the…NTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…NTSB MIA88FA127Accident · 1 fatalField investigationFinal reportMooney M-20J · Fernandina Bch, FLThe private pilot flew a flight that consumed about 31 gallons of fuel from a 31 gallon tank. The other fuel tank still had 31 gallons of fuel. The engine failed on base leg and the aircraft crashed in a wooded area. The pilot did not switch the fuel selector…NTSB LAX88LA132Accident · No injuriesLimited investigationFinal reportCessna 172Q · Prescott, AZNTSB LAX88LA128Accident · No injuriesLimited investigationFinal reportCessna 150M · Lodi, CAOn the day of the accident, the pilot departed lancaster, California, flew to fresno to pick up a passenger and then continued on to Lodi, the ultimate destination. While being vectored toward the airport at Lodi, the engine quit and the aircraft collided…NTSB LAX88DVD03Accident · Serious injuriesFinal reportPaxton RV-3A · Antioch, CAWhile performing aerobatic maneuvers, the aircraft was seen to have entered a spin. At approximately 300 feet the aircraft recovered, however, the left wing was seen to be bent upward and the fiberglass tip was dangling from the wing. The aircraft impacted…NTSB FTW88LA080Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Tomball, TXAs the helicopter lifted off the portable landing platform, it rolled to the right and contacted the terrain. The pilot could not determine if the skid was caught on the platform or if it slid off the side.NTSB ATL88LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, ALThe plt rptd that he observed the engine oil pressure indication drop to zero during a low-level pipeline patrol flight. He attempted to increase engine pwr and initiate a climb, but the engine began to run rough. He subsequently landed on the pipeline…NTSB NYC88LA108Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe acft was returning to the airport for landing after an instructional flight with a student. The student was landing the aircraft but when snow showers were encountered while flying downwind, the instructor pilot took control. He stated that he was landing…NTSB MIA88LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Dorado, PRWhile on a personal flt in normal cruise at an alt of 1000 ft aprx 2 miles southeast of the arpt, the eng began to misfire and the cabin filled with smoke. The plt elected to land in a clearing. The plt also stated that the eng was losing pwr and tht a/c…NTSB LAX88LA127Accident · No injuriesLimited investigationFinal reportBeech C23 · Placerville, CAJust after touch-down, the pilot stated that a deer darted out in front of the aircraft. The pilot did not have time to avoid colliding with the animal.