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 CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB CHI88LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Butler, INDuring a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped…NTSB ANC88LA147Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Zacher Bay, AKThe pilot stated that during the takeoff run on the water, he lost directional control of the airplane, due to the high wind condition. The airplane's wing tip struck the water causing the airplane to nose over on its back.NTSB SEA88LA187Accident · No injuriesLimited investigationFinal reportCessna 210L · Juneau, AKThe plt stated that on landing on the airstrip, which also serves as a roadway, he encountered a depression in the surface. The acft porpoised and departed the left side of the prepared surface. The plt added power and regained the prepared surface. He then…NTSB SEA88LA186Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Seattle, WAPlt received ATIS info which advised of gusty crosswind conditions and low level wind shear and recommended contacting Seattle radio(fss) for further info. Plt did not contact fss and initiated takeoff. At 100-200 ft AGL, acft encountered turbulence, pitched…NTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.NTSB SEA88LA184Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Eugene, ORPlt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…NTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…NTSB LAX88FA327Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Fullerton, CAFailure of the pilot to properly preflight the acft followed by loss of power during takeoff. The plt also failed to about the takeoff.NTSB CHI88LA243Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Benson, MNWitnesses reported that the aircraft bounced twice on the runway before the right wing tip struck the ground on the right side of the runway. The aircraft 'cartwheeled' and came to a rest on it's left side.NTSB BFO88LA084Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Princess Anne, MDThe pilot reported that he had sprayed aprx 1/2 of the soybean field when smoke started to fill the cockpit. He shut off the spray, turned off the electrical system and opened the fresh air vents. He then looked back at the tail section of the airplane and…NTSB SEA88LA183Accident · 1 fatalLimited investigationFinal reportCessna 150L · Hadlock, WAThe recently certificated pilot departed on a two hour round-robin flight to attend a meeting and was advised to expect fog on return. The aircraft was flown for one hour prior to this flight and was not refueled. No record of a wx brief was found. Prior to…NTSB NYC88FA238Accident · Serious injuriesField investigationFinal reportde Havilland DH-7-58C · Albany, NYThe acft experienced an uncontained disintegration of the no.2 engine. Scorched engine fragments ripped through the fuselage injuring two passengers, one seriously. The uncontained failure was the result of wear or spalling of the 1st stage reduction gear and…NTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…NTSB LAX88DVA15Accident · No injuriesFinal reportSchweizer G-164A · Laton, CANTSB FTW88IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Dfw Airport, TXFatigue failure of the left main landing gear door actuator pivot trunnion shaft which subsequently became lodged in the actuator clevis preventing the door unlock mechanism from actuating during gear extension.NTSB DEN88LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kerrville, TXThe commercial plt was 6 miles from his ranch and noted smoke in the cockpit, accompanied by a rough running engine. He turned back to the ranch for a forced landing. He overflew the landing area, decided he was too high for landing and turned for another…NTSB CHI88LA241Accident · No injuriesLimited investigationFinal reportCessna 550 · Fremont, MIThe airplane ran off the end of the runway and struck an embankment after landing downwind from a VOR approach during heavy rain. Both pilots reported poor braking action and ineffectiveness of reverse thrust application after touchdown and during the landing…NTSB ATL88LA253Accident · No injuriesLimited investigationFinal reportCessna 150G · Luverne, ALThe plt reported that he was flying at about 7-800 ft AGL while inspecting timber for insect damage when the engine suddenly lost power. He could not recover enough power to sustain flt, so he selected a pasture for his impending forced ldg. He reported that…NTSB ANC88LA146Accident · No injuriesLimited investigationFinal reportCessna 207A · New Koliganek, AKThe pilot reported that he landed long on a rough 900' gravel strip. He was unable to stop the airplane before it went off the end of the runway and into the adjoining tundra.NTSB NYC88IA246Incident · Minor injuriesIncident investigationFinal reportBoeing 747-100 · Georgetown, GuyanaIncident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter.NTSB MKC88FA175Accident · 1 fatalField investigationFinal reportCessna 310R · Latimer, IAThe pilot had completed his normal flight schedule and was assigned an additional trip from des moines, Iowa to st paul, Minnesota. Calculations show that the pilot had flown an estimated 5 hours in the 8 1/2 hours preceding the accident. The line attendant…NTSB MIA88LA270Accident · No injuriesLimited investigationFinal reportCessna 172 · Panacea, FLThe pilot stated that while attempting a go-around he inadvertently selected all flaps up and the aircraft crashed into the trees at the end of the runway.NTSB CHI88DET06Accident · 1 fatalFinal reportJones None · Elkhart, INInadequate aircraft design which resulted unacceptable aircraft takeoff and climb capability.NTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…NTSB ANC88LA145Accident · No injuriesLimited investigationFinal reportCessna 185F · Chip River, AKThe air taxi pilot was attempting to land on the snow covered tundra near his passenger's fish camp. The tundra had not yet frozen sufficiently to support the weight of the airplane, and the main landing gear quickly became mired in the soft soil, causing the…NTSB LAX88LA326Accident · No injuriesLimited investigationFinal reportCessna 172L · Banning, CADuring a crosscountry flt, while enroute from lake havasu city, AZ, to Banning, CA, the engine experienced a loss of power. The airplane collided with the terrain after a forced landing. Inspection of the fuel system revealed there was no fuel on board.NTSB DEN88LA208Accident · No injuriesLimited investigationFinal reportCessna 421B · Winner, SDThe private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…NTSB DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…NTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.NTSB SEA88LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Bend, ORAt aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost…NTSB LAX88LA324Accident · No injuriesLimited investigationFinal reportRobinson R22-HP · Yosemite, CAThe pilot was flying in high terrain at 10,000 ft MSL when he noticed his airspeed had dropped to 0. He stated that he had encountered a strong tailwind and he lost control of the helicopter. The helicopter collided with the terrain in an uncontrolled…NTSB FTW88DRD21Accident · No injuriesFinal reportAir Tractor AT301 · Ferriday, LAThe agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.…NTSB FTW88DPA08Accident · No injuriesFinal reportNorth American TB-25N · Wichita Falls, TXDuring a period of light rain at dusk, the B-25 plt landed on a 4250 ft rwy. While landing, the acft touched down long & fast. Subsequently, it went off the departure end of the rwy & was damaged.NTSB DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, CONTSB NYC88LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt.Holly, NJSeveral landings and takeoffs were performed. On the last landing, the aircraft touched down first on the right main gear and then the left main gear. The pilot stated that the aircraft seemed to slide or skid to the right and continued onto the grassy area…NTSB LAX88FA321Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Bear, CAThe pilot failed to maintain airspeed during takeoff. Contributing factors related to the high density altitude condition, the aircraft's excessive weight and the pilot's failure to lean the mixture. Also contributing to the accident was the pilot's improper…NTSB LAX88DUG07Accident · No injuriesFinal reportBell 47G-5A · Perris, CAOn liftoff, tail rotor control was lost and helicopter spun with main rotor striking terrain. Investigation revealed fatigue failure of engine mounting cage. The eng basket had failed and allowed the t/r drive shaft to pull out of the coupling. The basket had…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB FTW88DPA09Accident · Minor injuriesFinal reportAeronca 11AC · Athens, TXAfter setting the aircraft down in the grass to the left of the runway, the pilot stated that a 40 mph wind gust picked the right wing up and set the aircraft on its nose. He attempted to keep the fuselage from tipping all the way over after disembarking;…NTSB CHI88LA239Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Celina, OHAfter 2 unsuccessful attempts to takeoff, the plt/owner tried a 3rd takeoff in his newly purchased helicopter. He rprtd that during the first 2 attempts to takeoff, he couldn't seem to get 100% of his left pedal authority. Shortly after the helicopter became…NTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…NTSB CHI88FA237Accident · 2 fatalField investigationFinal reportCessna 182RG · Zanesville, OHThe pilot's poor judgement/decision-making, and his over confidence in his own ability which led to his repeated decisions to operate his aircraft in adverse weather conditions. The fact that the pilot had operated the aircraft in adverse weather conditions…NTSB CHI88DEG01Accident · No injuriesFinal reportPiper PA-22-160 · Jackson, OHWhile in cruise flight, the eng began running rough & would not produce enough power to maintain level flt. The plt selected a pasture for an emergency landing. Just before landing, the acft struck & severed a transmission line. It then brushed a treetop &…NTSB ANC88LA143Accident · No injuriesLimited investigationFinal reportMaule M-4 · Cordova, AKWhile on base leg to the airport, the engine stopped producing power forcing the pilot to land the airplane on the tundra short of the runway. Upon landing the airplane nosed over. Subsequent examination of the engine showed water in the carburetor. The water…NTSB SEA88LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cottage Grove, ORWhen plt realized strong headwinds at cruise alt would preclude reaching intended destination, he attempted to divert to another alternate. Fuel exhaustion occurred before reaching arpt. During a lndg, executed in dark, acft collided with a fence.NTSB NYC88LA237Accident · No injuriesLimited investigationFinal reportRobinson R-22 · W.Kingston, RIThe plt said it was a clear, calm night. When he got to his helicopter he found the windshield covered with a heavy dew. He cleaned the windshield but during takeoff the dew reformed on the windshield and he lost all visual references outside the helicopter.…NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.NTSB MIA88FA269Accident · 1 fatalField investigationFinal reportCessna 305A · Tampa, FLPlt experienced complete loss of engine power while climbing through 200 ft. the aircraft stalled and mushed, descending out of control and crashing to the ground. The engine was operated to full power after the accident. The cause of the loss of engine power…NTSB LAX88LA325Accident · No injuriesLimited investigationFinal reportBell 206L · Lihue, HIDuring a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine…