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 CHI84IA127Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Erlanger, KYWhile the acft was about 15 mi sw of the arpt being vectored for a rwy 36 cat ii approach, the local controller gave theground controller permission to clear snow removal equipment to proceed north on rwy 36 & to exit rwy 36 at the intersection of rwy 27L.…NTSB ANC84LA041Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Mcgrath, AKThe pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground.NTSB MKC84LA096Accident · No injuriesLimited investigationFinal reportCessna 172P · Broken Bow, NEA gust of wind overturned the acft during taxi from landing. The wind was from 330 degrees at 24 KTS gusting to 34 KTS.NTSB LAX84LA210Accident · No injuriesLimited investigationFinal reportMaule M6235 · Mesa, AZThe acft dragged a wing and nosed down into the ground collapsing the landing gear and sliding to a stop on a taxi-way during an attempted go-around after an alignment with rwy problem. The CFI said that the student plt used excessive rudder and 'froze' on…NTSB LAX84LA208Accident · No injuriesLimited investigationFinal reportAir Tractor AT-300 · Delano, CAThe plt was making a tight, 180 degree, right turn from downwind to final when he felt a buffet. He then applied power and lowered the nose. He stated he remained in the turn to avoid power lines. The power lines were located along the left side of the rwy.…NTSB LAX84FU025Accident · 1 fatalFinal reportWizard J-3BR503 · Lake Elsinore, CAThe acft collided with the ground in a past vertical inverted position. The wings failed in negative load after the plt lost control in pitch with the airspeed decreasing and stalled into a dive. The plt was on his first solo flt and his instructor was…NTSB ATL84FA119Accident · No injuriesField investigationFinal reportPiper PA-31T · Benson, NCA Piper PA-31T, N9162Y, and a Beech 200C, N390AC, were involved in a midair collision while both were cruising at 17,500 ft in unlimited visibility. The Piper was tracking inbound on the 210 deg radial of the richmond VOR. The Beech was tracking inbound on…NTSB ATL84FA118Accident · No injuriesField investigationFinal reportPiper PA 31-350 · Atlanta, GAThe aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the…NTSB NYC84LA103Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-8 · Tobyhanna, PAThe acft made a precautionary landing on a highway after both engines lost oil pressure. The plt feathered the right propeller because it gave abnormal indications before the left engine. The left engine was still operating at touchdown post accident…NTSB FTW84LA159Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Lamesa, TXShortly after takeoff for an aerial application flight a partial loss of power occurred. A hard forced landing was made in an open field which resulted in both main gears collapsing. Inspection of the engine revealed both magneto distributor blocks were…NTSB FTW84FA156Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Fort Worth, TXThe acft made a forced landing in an open field near the arpt when the right engine stopped at about 50-100 ft AGL during a touch and go landing. The CFI aboard said he had positioned the fuel tank selector to the inboard tanks prior to the last approach or…NTSB DEN84LA105Accident · No injuriesLimited investigationFinal reportCallair A · Tremonton, UTThe acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the…NTSB ATL84MA114Accident · 6 fatalMajor investigationFinal reportCessna 421B · Cullman, ALPlt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west…NTSB ATL84FA116Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Manassas, VAThe accident occurred on missed approach at night in weather conditions below the destination minimums after aprx 5 hours and 25 minutes of flight. Performance computations indicated the accident occurred at or near the time of projected fuel exhaustion.…NTSB ATL84FA115Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Spartanburg, SCThe acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep…NTSB ANC84LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Iliamna, AKThe acft cowling came unfastened during cruise and the plt elected to make a precautionary landing. During the landing, the plt lost directional control and collided with a snowbank.NTSB NYC84MA102Accident · 3 fatalMajor investigationFinal reportPiper PA-31 · Cumberland, MDApprox 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy…NTSB LAX84LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · San Luis Obispo, CAThe acft spiraled down and collided with the ground while turning from base leg to final in the traffic pattern. The pltsaid he tried to correct the situation but the sprial continued. No evidence was found to support the plts claim that the acft crashed…NTSB LAX84LA206Accident · No injuriesLimited investigationFinal reportCessna 170B · Fullerton, CAThe acft ran off the rwy during landing. The plt said the'right brake was not functioning properly.' The acft collided with a rwy light and collapsed the right main gear.NTSB ATL84FKG05Accident · 1 fatalFinal reportPiper PA-34-220T · Madison, GAThe acft collided with a car while landing on an airstrip at night. The car had been parked on the strip & an occupant in the car was fatally injured. An illicit substance was found aboard the acft & it was confiscated by law enforcement officials. Rain & fog…NTSB NYC84LA101Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe student plt was practicing touch and go landings. The plt reported that the acft encountered a strong gust of wind about 5 ft AGL during the 2nd landing. The touchdown was made on the right main gear as the acft skidded and bounced. The next landing was…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB NYC84LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Bedford, MAThe acft was decelerating at about 35 mph during roll when a gust of wind picked up the right wing and the acft veered to the right. Full power was applied to regain control and during acceleration the right main gear collapsed and the acft pivoted right and…NTSB NYC84LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Elmira, NYThe acft was descending to land when the engine quit. The pilot attempted to restart the engine with negative results and made a forced landing into a plowed field. The weather conditions were conducive to carburetor ice.NTSB MKC84FA091Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Harrison, ARThe plt encountered a thunderstorm during a night x-country. The plt was being vectored by the controller to avoid the worst of the storm. After about 2 minutes memphis center heard the acfts call sign shouted over the radio. Further attempts at radio…NTSB MIA84LA097Accident · No injuriesLimited investigationFinal reportGardner Steen SKY Bont · Milton, FLThis was the initial test flt of the homebuilt acft. During takeoff the eng quit. The right landing gear caught on a guy wire during the emergency landing & the acft flipped. The plt/builder, who is a certified mechanic, attributed the power loss to a…NTSB MIA84LA096Accident · No injuriesLimited investigationFinal reportHeinemann Rotorway Executive · Ft. Lauderdale, FLThe commercial/atp plt was not rated for helicopters. He stated that 'while in flt position' to check the cyclic pressures, a strong gust of wind lifted the helicopter off the ground & rolled it over on its side. He believed that this would not have happened…NTSB LAX84LA205Accident · No injuriesLimited investigationFinal reportBeech BE-24 · La Verne, CAThe acft collided with the ground short of the rwy during an ILS approach. The plt said he took his eyes off the panel to look outside and got off the glide slope. The plt also said the weather was below approach minimums. The ILS was checked by FAA after the…NTSB FTW84FA153Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Lampasas, TXThe captain received a company briefing prior to the flt. A convective SIGMET was in effect & turbulence was forcast for the area. During flt, the acft was manuevered to avoid turbulence. The acft was clear of clouds & in a thin haze layer when the crew felt…NTSB DEN84FU002Accident · 1 fatalFinal reportEipper Quicksilver MX · Libby, MTAccording to witnesses, the ultralight vehicle was on an apch to the arpt when it entered a left descending turn & continued the turn until impacting a tree. One witness said the plt was bent over forward. Reportedly, the plt made no movements with his hands…NTSB CHI84LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Strongsville, OHThe CFI stated that on the second landing, during the flare, the acft veered off the left side of the rwy due to the rt crosswind. He stated that he attempted to take control of the acft but it was already off the rwy in a two to three ft deep snowbank. The…NTSB ATL84LID01Accident · No injuriesFinal reportChampion S-150 · Ft. Eustis, VAThe plt reported that he made a smooth landing using full flaps. He stated that suddenly with no warning, the left wing came up and the right wing hit the runway. The acft went off the left side of the runway and the rt main gear collapsed. Investigation…NTSB ATL84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rockingham, NCN92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost.NTSB ANC84LA039Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-100 · Glennallen, AKThe plt experienced a downdraft, while approaching a glacier at 5500 ft MSL. In turning downgrade to try to affect a descent of the acft, control was lost and the helicopter collided with the ground. The acft rolled inverted after ground contact.NTSB SEA84FA065Accident · 5 fatalField investigationFinal reportPiper PA-28-181 · Lewiston, IDThe acft crashed in mountainous terrain while the non-instrument rated plt was on a flt in marginal wx conditions. An investigation revealed that the acft had impacted in a steep nose down, high speed descent. No preimpact/mechanical problem was found. About…NTSB NYC84LA329Accident · 2 fatalLimited investigationFinal reportCessna U206A · North Hudson, NYAn inflight collision with trees in an area of high terrain. Factors related to the accident were: the pilot's decision to takeoff after he received a briefing advising, 'VFR flight not recommended', the dark night conditions, and snow showers.NTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.NTSB NYC84LA099Accident · No injuriesLimited investigationFinal reportCessna 402B · Penn Yan, NYThe acft entered a high sink rate during the final approach and collided with the ground. The plt managed to get the acft onto the rwy but the right main landing gear collapsed during the landing roll. A culvert is located near the approach end of rwy 28.NTSB MKC84FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Oconto, NEAfter attending a business conference at muncie, IN, the plt received a wx briefing & took off at 2026 CST on a flt to des moines, IA, where he refueled. In a phone call to his wife at their home in north platte, NE, he indicated the wx was such that he would…NTSB FTW84LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Braithwaite, LAThe plt said that when he applied power for takeoff he overcorrected and the acft veered right. He attempted to abort but saw a ditch and reapplied power. The acft hit the ditch and collapsed the landing gear. The plt thought maybe the brakes locked but an…NTSB FTW84LA154Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Intracstl City, LAThe helicopter collided with marsh terrain while spotting dead alligators. The plt does not remember events of the accident. The helicopter operator stated the helicopter appeared to have impacted at a low airspeed at a normal RPM. The emergemcy floats were…NTSB DEN84LA104Accident · No injuriesLimited investigationFinal reportGates Learjet 25D · Denver, COAbout 1 mi from the arpt while established on the glide slope, the plt was advised by the controller to go around due totraffic on the ground. Just after the plt advanced the throttles & retracted the landing gear, the controller again cleared the plt for…NTSB CHI84LA129Accident · No injuriesLimited investigationFinal reportCessna 150M · Hagerstown, INDuring the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.NTSB CHI84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Taylorville, ILThe acft collided with a snowbank and nosed over during landing. The student plt said a nose wheel shimmy developed during landing roll and he was unable to keep the acft on the 6O ft wide rwy.NTSB ATL84LLT05Accident · Minor injuriesFinal reportCessna C-172F · Pascagoula, MSThe plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.NTSB ATL84LA112Accident · No injuriesLimited investigationFinal reportCessna P210N · Kennesaw, GAThe acft crashed during a forced landing after a power loss. The plt stated during a post accident interview that he didnot switch tanks during the power loss sequence. Investigation revealed that the right fuel tank was empty. About 1/2 oz of fuel was…NTSB ATL84IA117Incident · No injuriesIncident investigationFinal reportBeech 19A Sport III · Atlanta, GAThe student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright.NTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…NTSB NYC84FA096Accident · Serious injuriesField investigationFinal reportCessna A185F · Waitsfield, VTThe acft collided with trees during takeoff. The rwy was snow covered 4 to 6 inches deep and was only 1800 ft long. The takeoff was on a bearing of 130 degrees. The wind was from 280 degrees at 14 KTS. The skis on the acft had wheels protruding through at the…NTSB FTW84LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKBefore takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for…