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 DEN88LA188Accident · No injuriesLimited investigationFinal reportCessna T210F · Ennis, MTWhile on a landing rollout, the left main gear strut failed & separated from the acft. The plt said he held the acft straight for about 600 ft, then it veered to the left & went off the rwy. Subsequently, the left wing & left horizontal stabilizer were…NTSB DEN88LA187Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leadville, COThe student plt was lost during a solo cross country instructional flight. After landing and refueling at Leadville, Colorado, he attempted to fly through a mountain pass towards his destination. He climbed the acft to 12,000 and tried to continue the climb.…NTSB CHI88IA217Incident · No injuriesIncident investigationFinal reportBell 206L · Indianapolis, INNTSB CHI88DEC06Accident · Minor injuriesFinal reportSackett J2 · Deckerville, MIThe pilot's poor judgement and misjudged perceptions while practicing takeoffs and landings in an unfamiliar aircraft. The pilot executed a hard landing, touching down short of the runway and collapsing the landing gear. The aircraft skidded to a stop on the…NTSB SEA88LA155Accident · 1 fatalLimited investigationFinal reportMace R-2 · Reno, NVAcft had been fitted with new outer wing panels of elliptical design and was on sixth test flight for racing certification, exploring g envelope. Investigation revealed right outer panel separated in flight during maneuvering. Failure occurred in center…NTSB SEA88FA156Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 Mark 1 · Sitka, AKWhile on a flight from Sitka to rowan bay, Alaska, the pilot flew up a valley intending to cross a pass whose elevation was 2745 feet MSL. Upon approaching the pass the pilot encountered clouds which prevented his transit. The pilot then executed a 180 degree…NTSB NYC88LA221Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Wellsville, PAA private plt on a local flight made a stopover landing on runway 28. The plt reported that during the landing flare, he was temporarily blinded by the setting sun directly in the flight path. At touchdown the airplane weathervaned into the right crosswind,…NTSB MIA88IA256Incident · No injuriesIncident investigationFinal reportBellanca 8KCAB · Miami, FLWhile on a personal flt during normal cruise, the plt reported that the cockpit filled with smoke. He turned off the electrical system & secured the eng, then attempted a precautionary landing on a grass strip. The acft landed long, overran the rwy, & nosed…NTSB LAX88LA288Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · Camarillo, CADuring a cross country flight, the pilot reported that he was 'scud running' to the airport. The pilot was following a road that ran near the airport, however, the pilot lost sight of the road. The pilot decided to divert to another airport and then the…NTSB FTW88LA153Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXThe helicopter was at 300 feet AGL, making an approach after a maintenance test flight, when the engine overtemped and engine power was lost. During the autorotation landing, the helicopter touched down hard. The acft eng began to decelerate prior to…NTSB DEN88LA190Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COThe commercial plt was practicing short field landings from the right seat on a 7,498 x 100 ft asphalt rwy. The plt said he encountered a thermal at 10 ft AGL and stalled the airplane. He reported that the acft hit harder than he expected and bounced twice.…NTSB DEN88FA186Accident · 2 fatalField investigationFinal reportLuscombe 8A · Dimock, SDThe plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked…NTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…NTSB CHI88DEM10Accident · No injuriesFinal reportGrumman G-164B · Schoolcraft, MIThe pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.…NTSB ANC88LA115Accident · No injuriesLimited investigationFinal reportPiper PA-12 · King Mountain, AKThe pilot-in-command was maneuvering through a valley for the second time. During the second pass the engine lost power. Mixture was full rich, and the pilot applied carburetor heat and when nothing happened he turned the carburetor heat off. He attempted a…NTSB ANC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yenta Glacier, AKDuring the takeoff roll on the gravel bar, the pilot lost directional control of the airplane causing the plane to nose over on its back. Examination of the left brake revealed that the brake was frozen with mud.NTSB ANC88FA111Accident · 2 fatalField investigationFinal reportCessna 402B · Mt. Torbet, AKThe on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the…NTSB NYC88LA220Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Lakeville, MAAccording to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.…NTSB LAX88DUG06Accident · Minor injuriesFinal reportHiller UH-12E · Thermal, CAShortly after refueling the helicopter & reloading the hopper, the plt took off & was starting to spray a field when the eng suddenly lost power. The plt said the helicopter was dscndg from about 30 ft when the power loss occurred; thus, he barely had time to…NTSB DEN88LA184Accident · No injuriesLimited investigationFinal reportCessna A185F · Medicine Bow, WYThe pvt plt returned to his ranch strip & landed to the ene with a x-wind from the right. Drg the lndg roll, the acft began to go to the right. The plt corrected with left pedal, but subsequently, the acft ground looped to the left & nosed over. An exam of…NTSB CHI88LA212Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Crandon, WIDuring cruise flight in deteriorating meteorological conditions, the pilot experienced a total loss of engine power. The pilot performed emergency procedures, was unable to restart the engine, and executed a forced landing in a clover field. The aircraft…NTSB CHI88DEP11Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Plover, WIThe aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944…NTSB ATL88FA231Accident · 1 fatalField investigationFinal reportCessna 172 · Adel, GAThe pilot had been briefed on the weather conditions along the intended route of flight. VFR flight was not recommended. The pilot elected to land at his alternate, and had reported visual contact. Local witnesses reported low ceilings and reduced visibility.…NTSB SEA88FA154Accident · 2 fatalField investigationFinal reportCessna 210E · N Bonneville, WAWhile on a flt from oroville to orchards, WA, the acft was about 25 to 30 mi east of the destn when it collided with trees & crashed. Impact occurred aprx 100 ft below the top of a ridgeline at an elev of about 1755 ft. a witness, who heard the crash, rprtd…NTSB NYC88LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Georges Mills, NHWitnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB MIA88IA255Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe CFI & his pvt plt-rated multi eng student were conducting touch & go ldgs in preparation for the multi-eng rating. The CFI stated that one of the ldgs was harder than usual, but not overly hard. On the next aprch, they noticed the rt gear indicator was…NTSB LAX88LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · Jackson, CAJust after takeoff, the engine quit at aprx 50 ft AGL. The pilot made an emergency forced landing off the runway, where during the landing roll the airplane collided into a fence. There were no mechanical failures or malfunctions found during an engine…NTSB CHI88FA205Accident · Minor injuriesField investigationFinal reportFairchild SA-226-TC · Cleveland, OHThe captain's late decision to abort after a propeller linkage failure on the right engine and the co-pilot's failure to relinquish engine and braking authority to the captain resulting in confusion and inadequate braking to stop on the runway after the abort.NTSB ATL88FA230Accident · 3 fatalField investigationFinal reportBeech 60 · Pageland, SCThe airplane was observed to approach the airport from the northwest. As it crossed the northeast end of the runway, it initiated a right turn to cross the runway about the midpoint to a position for a left downwind for landing on runway 5. Its altitude was…NTSB ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCNTSB SEA88LA153Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Oreana, IDPlt was circling a friend's ranch at low alt when acft began an uncommanded left roll. Plt was able to level wings before ground contact in rough terrain. Investigation revealed aileron attach bolt missing. Aileron had just undergone repair.NTSB NYC88FA218Accident · 1 fatalField investigationFinal reportCessna 172K · Island Falls, MEPilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.NTSB MKC88LA159Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Swifton, ARShortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused…NTSB LAX88LA287Accident · No injuriesLimited investigationFinal reportCessna T210N · Culver City, CADuring a pleasure flight, the engine experienced a loss of power. A forced landing was made during which the airplane collided with wires and was substantially damaged. During the inspection of the airplane, the fuel tanks were found exhausted of fuel.NTSB CHI88LA208Accident · No injuriesLimited investigationFinal reportBeech C55 · Cahokia, ILWhile on a maintenance test hop after annual inspection, the pilot failed to insure that the landing gear was extended before touchdown. The pilot stated that the gear handle was placed in the gear down position, and that no gear warning horn sounded during…NTSB CHI88LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Eden Prairie, MNOn landing the aircraft bounced resulting in a porpoise. The nose gear collapsed rendering substantial damage to the aircraft.NTSB CHI88FA206Accident · 1 fatalField investigationFinal reportAeronca 7CCM · Barker, NYThe pilot in command failed to maintain control of the airplane.NTSB CHI88DEM09Accident · No injuriesFinal reportHulliberger Starduster II · White Cloud, MIUnauthorized pilot failed to maintain adequate control of the homebuilt aircraft during the landing roll. The aircraft veered off the right side of the runway, and the left wing struck the ground.NTSB ANC88LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKDuring the takeoff roll on a gravel bar, the pilot lost directional control of the airplane & it bounced into the river. The airplane then nosed over on its back. The pilot and passenger both exited the airplane.NTSB SEA88LA151Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Fallon, NVEng lost power on practice missed approach. Forced landing made in rough terrain. Investigation revealed right fuel tank empty, left tank contained about 25 gals. Fuel selector had no positive stop at 'off' position, no detent for right tank position. Left…NTSB NYC88LA217Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Wellsboro, PAThe pilot attempting a takeoff in an over grossed aiarcraft in high density altitude and flew off the end of the runway into high grass.NTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…NTSB LAX88LA285Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Lake Arrowhead, CADuring a local parachute jump flight, the airplane was unable to gain enough altitude to clear rising terrain. The airplane collided with a tree and eventually the terrain. There were no reported mechanical failures or malfunctions. The acft handbook lists…NTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…NTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…NTSB CHI88LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hobart, INWhile on a solo instructional flight for the purpose of practicing crosswind takeoffs and landings, the student pilot failed to adequately compensate for the crosswind and experienced a loss of directional control shortly after the aircraft touched down. The…NTSB CHI88LA210Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Montgomery, OHWhile on a local pleasure night flight, in normal cruise configuration, the pilot experienced a loss of engine power due to fuel contamination and executed a forced landing on a highway exit ramp. The pilot stated that he attempted to make the forced landing…