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 DEN88FA119Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Maljamar, NMWhile in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both…NTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…NTSB ANC88LA091Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Nikolai Creek, AKA pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch.NTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…NTSB ANC88LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Chugiak, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway.NTSB ANC88FA065Accident · 3 fatalField investigationFinal reportCessna 172N · Hatcher Pass, AKThe aircraft crashed at the 3100 foot level of a mountain Pass. The aircraft was destroyed by ground impact and fire, and the pilot and the two passengers were fatally injured. Witnesses near the crash site stated the aircraft was maneuvering very low above…NTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…NTSB MIA88LA186Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Callahan, FLWhile maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the…NTSB MIA88LA185Accident · No injuriesLimited investigationFinal reportBost Pitts S-1C · Miami, FLThe plt stated that he was performing a tail-slide maneuver when the eng suddenly quit. He attempted to restart eng. When eng would not restart, he elected to lnd a/c in a fld. During landing roll, the a/c nosed over. FAA stated that the carb was damaged…NTSB MIA88LA183Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gretna, FLWhile on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on…NTSB MIA88FA184Accident · 2 fatalField investigationFinal reportPiper J3C · N Fort Myers, FLThe plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,…NTSB LAX88LA207Accident · No injuriesLimited investigationFinal reportBeech M35 · Scottsdale, AZDuring the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke.NTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…NTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, CONTSB DEN88LA116Accident · Serious injuriesLimited investigationFinal reportCessna TR-182RG · Englewood, COThe CFI, a private rated dual student, and one passenger were preparing to depart on a training flight. The CFI attempted to hand prop the airplane when the battery was found to be inoperative. During the attempt, the CFI was struck in the back of the head.NTSB DCA88IA060Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Jamaica, NYNone submittedNTSB MKC88LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hickory Ridge, ARWhile executing a standard procedure aerial application turn around maneuver, the acft began to settle. The plt dumped his remaining chemical load, but acft continued to settle, and mushed into the trees. Post accident fire destroyed the acft, but the plt…NTSB MIA88LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLWhile on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off…NTSB FTW88DRG10Accident · Minor injuriesFinal reportPiper PA-28RT-201 · Lampasas, TXThe pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,…NTSB CHI88LA124Accident · No injuriesLimited investigationFinal reportBeech B-19A · Lacon, ILA hard landing made by the student pilot after attempting to recover from a bounced landing.NTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.NTSB CHI88DEM05Accident · No injuriesFinal reportBell 47G-2A · Midland, MIThe plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…NTSB SEA88LA101Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lester State, WAThe pilot inadvertently flew into a narrow valley with trees on both sides and steep rising terrain during climb to cruise. The aircraft was not able to outclimb the rising terrain, so the pilot slowed the aircraft to 40 m.p.h. and attempted a shallow…NTSB NYC88LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Dover, PALoss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree).NTSB NYC88DGT02Accident · Minor injuriesFinal reportBell 47G3B1 · Cove Gap, PAThe helicopter plt was taking off from an area surrounded by trees & buildings for a local spray operation. The wind was calm. Reportedly, during the attempted departure, the plt 'exhausted all power available then made right turn to return to field.' After…NTSB MKC88LA102Accident · No injuriesLimited investigationFinal reportPitts S-2 · Siloam Springs, ARThe pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall.NTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…NTSB LAX88LA206Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Long Beach, CAWhile on final approach to the runway, the engine quit. During the forced landing the empennage caught on the airport boundary fence. The airplane collided with the terrain and nosed over. Inspection of the fuel tanks revealed that one tank was empty and the…NTSB LAX88LA203Accident · Minor injuriesLimited investigationFinal reportBell 206B · Honolulu, HIDuring a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin…NTSB LAX88FA204Accident · 2 fatalField investigationFinal reportTaylorcraft BL65 · Eloy, AZFailure of the pilot to maintain control of the aircraft during takeoff climb resulting in an inadvertent spiral. Contributing to this accident was the pilot's lack of total experience in the aircraft make and model.NTSB LAX88FA196Accident · 1 fatalField investigationFinal reportBeech H-35 · Phoenix, AZThe plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the…NTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILNTSB SEA88LA102Accident · No injuriesLimited investigationFinal reportBeech B55 · Reno, NVThe pilot was attempting to land on runway 25 with winds from 290 degrees at 17 knots. Just prior to flare, the aircraft encountered a gust of wind. The pilot lost control of the aircraft and landed hard on the right main gear. The right strut, wheel and…NTSB NYC88LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · W. Peru, METhe cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.…NTSB NYC88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Franconia, NHThe pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and…NTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…NTSB NYC88LA150Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJLoss of power due ot vapor lock of the aircraft engine and an off airport landing and collision with an object.NTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…NTSB NYC88DFA01Accident · No injuriesFinal reportLloyd Feary VJ-22 · Kingston, NYThe aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted…NTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…NTSB MKC88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Des Moines, IADuring a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel…NTSB LAX88FA215Accident · 4 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAInflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot , which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects…NTSB LAX88FA197Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pinecrest, CAPilots decision to continue VFR flight through a mountain area after encountering instrument meteorological conditions.NTSB FTW88LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXThe instructor was simulating an engine-out emergency for the dual student. The student was making an approach to an emergency field with a line of trees on the approach end. When the instructor became aware that they might not reach the field, he directed…NTSB FTW88LA111Accident · No injuriesLimited investigationFinal reportCessna 210D · New Roads, LAThe airplane had not had an annual inspection and had not been flown for over a year. The pilot stated he found no contamination during the draining of the fuel sumps. Shortly after takeoff, the engine started sputtering and eventually stopped. During the…NTSB FTW88DQG05Accident · 1 fatalFinal reportPiper PA-25-260 · Stratford, TXWhile maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot.NTSB FTW88DQA01Accident · 1 fatalFinal reportAerotek Pitts S2S · El Paso, TXPilot's failure to complete the aerobatic maneuver in a manner which insured adequate terrain clearance at the termination.NTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…NTSB BFO88LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Milford, DEThe plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by…NTSB SEA88LA106Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Elgin, ORThe purpose of the flight was for the pilot to practice for his aerial applicators certificate. Water was being used instead of chemical. The pilot reported that as the aircraft began to accelerate during takeoff it began to oscillate. As in prior…