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 DEN86LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Alameda, NMThe student plt stated that during the landing, the aircraft bounced twice before it's nose gear collapsed. The student pilot said the aircraft nosed over onto its back following the nose gear collapse.NTSB ATL86LA078Accident · No injuriesLimited investigationFinal reportCessna 172N · Washington, NCThe student pilot stated that the aircraft encountered a gust of wind during landing flare causing the aircraft to drift to the left upon touchdown. In an attempt to correct for the drift the student pilot applied left brake pressure as well as left rudder…NTSB MKC86LA060Accident · No injuriesLimited investigationFinal reportBeech N35 · Hot Springs, ARThe pilot stated that he was on the landing roll and reached for the flap switch and moved the landing gear switch instead. The landing gear then retracted.NTSB LAX86FA120Accident · 1 fatalField investigationFinal reportCessna 172M · Carlsbad, CAAfter failing to see the runway on his first ILS approach in weather reported at IFR minimums for landing, the pilot was radar vectored for a second approach. According to controllers the approach appeared to be normal until the aircraft's radar target…NTSB DEN86LA079Accident · Minor injuriesLimited investigationFinal reportBell 47G3 B-2 · Grand Junction, COThe plt stated that while turning to the intended landing area, the helicopter he was piloting encountered both downdrafts & tailwind. The plt indicated the helicopter settled until grnd contact.NTSB CHI86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Rochester, MNDuring a ILS approach in freezing rain conditions the pilot entered a high sink rate he could not stop until ground contact. The acft touched down short of the rwy and all three landing gear collapsed.NTSB MKC86LA061Accident · Minor injuriesLimited investigationFinal reportSchweizer G164-B · Colt, ARThis was a new acft which the owner was ferrying from the dealer to his private ag strip. The landing was made to the north on a half mile long grass strip and the wind was calm. The plt reports that the brakes were locked when the acft touched down and the…NTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…NTSB FTW86LQG08Accident · No injuriesFinal reportWayne Mathews Glas AIR SH2R · Ranger, TXThe acft drifted left off the rwy during takeoff and collided with trees. This was a home built acft that had just been certified. The owner/builder had made high speed taxi runs but did not feel comfortable to fly it. Another plt was asked and after a short…NTSB DEN86FA077Accident · 3 fatalField investigationFinal reportCessna P210N · Dulce, NMThe plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the…NTSB NYC86LA075Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Indiana, PACessna 182 landed in deep snow off the right side of the runway. The aircraft touched down hard broke the nose wheel and the Cessna flipped over and received substantial damage. There was no fire. There were no injuries to the pilot and one passenger.. The…NTSB LAX86LA123Accident · No injuriesLimited investigationFinal reportGlobe Swift GC-1B · Upland, CAOn February 16, 1986 at 1515 PST, a swift GC-1B, N80561, collided with terrain after a forced landing. After t/o at approximately 400 feet AGL the engine began to run rough and the aircraft would not maintain altitude. Traffic on the rwy prevented an on apt…NTSB CHI86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Frankfort, ILFollowing a descent through icing conditions the plt was told by the UNICOM operator that the active rwy was 'slippery'.the plt landed aprx 600-700 ft down the 3176 ft rwy and found that the braking action deteriorated from poor to nil during rollout. He…NTSB CHI86LA087Accident · No injuriesLimited investigationFinal reportCessna 340A · Wheeling, ILAccording to the plt the left eng lost pwr at rotation. He could then not correct the left ground track deviation with right rudder. To avoid obstacles at the edge of the rwy he pulled the acft off the ground but the acft soon settled back down, sustaining…NTSB ATL86LA076Accident · Minor injuriesLimited investigationFinal reportPiper J3L-65 · Sevierville, TNDuring takeoff initial climb the engine lost power and a forced landing was initiated. During the descent the aircraft contacted treetops prior to ground impact. Post-crash examination of the engine disclosed that one of the cylinders had broken away from the…NTSB ATL86LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Lake Lure, NCThe plt contacted approach control for VFR staging to airport and radar service. The plt later indicated a forced landing was necessary due to fuel exhaustion. The plt calculated full fuel tanks for flt but failed to recall two local flights that were made…NTSB NYC86FA076Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1 · Jamaica, NYThe no. 3 eng torched during a start attempt and resulted in a internal eng tailcone fire. Several paxs panicked upon seeing the torch flame/tailcone fire and between 30 to 50 paxs made an unauthorized evacuation of the acft via the L3 and L4 exits. Paxs…NTSB MKC86FA059Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring a climb to cruise, the pilot-in-command declared an emergency & requested to dscnd & return to the arpt. The landing was uneventful. An exam of the left prop revealed that 1 of its 3 blades had failed at the butt end & had separated. Subsequently, the…NTSB MIA86LA079Accident · No injuriesLimited investigationFinal reportBeech 55 · Ft. Myers, FLThe plt stated that he had experienced an electrical failure & because it was getting dark, he could not see the mechanical landing gear position indicator. He said that he performed a 'gump' check & verified that the gear handle was in the down position, but…NTSB MIA86LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Clewiston, FLThe plt stated that a x-wind caused him to lose control of the acft while attempting to land on a x-country flt. The acft departed the rwy and struck a ditch. The plt indicated that no pre-flt wx briefing was obtained prior to departure.NTSB MIA86LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft. Pierce, FLThe flt was cruising at 2000 ft with the mixture leaned for cruise. A descent to 1000 ft was made by reducing power. Shortly after leveling off, the engine began to lose power and max RPM available was 1700. The plt said he pumped the throttle several times…NTSB ANC86LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccarthy, AKThe pilot stated that he touched down too hard and the main wheels broke through the crust on the snow. The pilot lost control of the aircraft causing the plane to nose over on its back.NTSB MIA86FA076Accident · 2 fatalField investigationFinal reportCessna 340A · Dania, FLShortly after takeoff on a check-out flight the aircraft was observed on crosswind leg to descend until impact. There was an extensive post impact fire. Witnesses heard the aircraft make a 'poof' type of noise just as the pilot radioed the control tower and…NTSB DEN86LA078Accident · No injuriesLimited investigationFinal reportCessna 182 · Wray, COAccording to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the…NTSB CHI86LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Cloud, MNThe plt was diverting into galesburg due to bad weather at his original destination. Following an ILS approach at galesburg he spotted the rwy at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…NTSB MIA86IA075Incident · No injuriesIncident investigationFinal reportPiper PA-31-1020 · Panama City, FLThe plt stated that all attempts to extend the landing gear were to no avail & he elected to land with the nose gear not fully locked down. On landing rollout the nose gear completely collapsed. Post crash examination of the nose landing gear revealed that…NTSB LAX86LA119Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Kalaupapa, HIThe acft crashed off the end of rwy 23 during an attempted go-around after touchdown. The plt stated that after the acft touched down aprx 300 ft down the 2,760 foot rwy he raised the flaps along with the nose of the acft to slow down. Brakes were applied and…NTSB ATL86FA074Accident · 1 fatalField investigationFinal reportCessna 303 · Shippenville, PAN4877V arrived over clarion county airport at about 2100 hours, and commenced a visual approach for landing. Marginal visual weather conditions prevailed at the time of the accident. The flight was observed by another pilot waiting on the ground for the…NTSB SEA86LA059Accident · No injuriesLimited investigationFinal reportAlon A2 · Woodburn, ORThe pilot was attempting to depart the sod 1300 foot runway and due to poor soft field technique failed to clear a fence.NTSB SEA86LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Renton, WAThe pilot failed to maintain directional control during takeoff. Although a crosswind from the left was present the pilot lost control for unknown reasons to the left, crossing the taxiway and then striking a parked vehicle and building. No mechanical reason…NTSB NYC86LA074Accident · No injuriesLimited investigationFinal reportUniversal Aircraft Industries GC-1B · Farmingdale, NYA Piper acft was standing in the runup area that is adjacent to taxiway A5. The plt of the globe acft taxied into the runup area and because the sun was in his eyes and the Piper was in his blind spot he ran into the Piper.NTSB MIA86LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Vero Beach, FLDuring auto-rotation practice, the CFI passed control of the helicopter to the student plt. At aprx 10 ft above the ground, the CFI attempted to apply corrective action when it became apparent that the acft was going to make a hard landing. The attempt was…NTSB LAX86LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Ontario, CAThe owner/plt (PIC) was on a flt for night & instrument currency requirements. He was flying the acft from the left front seat while a commercial plt (cp) was occupying the rgt front seat. Drg an ILS rwy 26L final apch at Ontario, CA, the PIC & cp discussed a…NTSB CHI86LA089Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Muncie, INThe pilot intentionally landed gear up after an electrical failure and the gear failed to extend normally. The alternator switches were found off after the accident. It was beginning to get dark with ceilings at 2200 ft.NTSB ATL86FLQ05Accident · Serious injuriesFinal reportBeech H-18 · Louisville, KYThe acft collided with the ground after stalling during takeoff. Witnesses reported that the acft pitched up in two increments, climbed sharply to about 200 ft AGL, stalled dropped the rt wing and descended, impacting the ground in a flat attitude.NTSB SEA86FA056Accident · 3 fatalField investigationFinal reportMcDonnell Douglas 369D · Cougar, WAThe helicopter departed the landing area after a night photography session across the valley floor from the Mt. St. Helens volcano. Prior to departure the plt reported the weather was closing in and getting 'nasty'. Wx conditions as reported prior to…NTSB ATL86LA073Accident · No injuriesLimited investigationFinal reportCessna U206B · Columbia, TNSoon after departure the plt experienced a severe vibration throughout the acft. Eng pwr was retarded and the vibration subsided. The plt then noticed aileron control problems and noticed the left wing tip was moving up and down. An emergency landing was made…NTSB ANC86MA027Accident · 3 fatalMajor investigationFinal reportCessna 207 · Nome, AKThe acft departed during a break in the wx after having waited for a special VFR departure. His departure radio call was the last communication from the flt. The wx remained marginal with icing in the clouds and freezing drizzle. The acft was on a flt to…NTSB MIA86WA073Accident · No injuriesForeign investigationPiper PA-32R-300 · Darby Island, BahamasNTSB LAX86LUQ02Accident · No injuriesFinal reportRutan Varieze · Los Almos, CAThe acft collided with a fence during a forced landing on a hiway after the engine lost power while cruising at 6500 ft MSL. The plt had refueled with 10 gals of fuel at santa barbara, CA his last departure point. Post acc exam showed the fuel tanks, lines…NTSB LAX86LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Francisco, CAOn feb 9, 1986 at 1717 PST a Piper PA-23, N5300Y, ditched approximately 460 NM sw of sfo, CA. The flt originated from hnl, HI. In flt fuel leak was discovered after 7 hrs of flight. Fuel vapors were seen contrailing off both wings. The plt attempted to…NTSB CHI86LA084Accident · No injuriesLimited investigationFinal reportCessna 207 · Milwaukee, WIAfter preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil…NTSB SEA86FA054Accident · Serious injuriesField investigationFinal reportCessna 172N · Renton, WAThe recently certificated private pilot was engaged in practice touch and go landings. Sometime after the second approach the throttle control rod became disconnected from the throttle cable and the pilot was unable to retard the throttle from a full power…NTSB LAX86LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAA Cessna 172 collided with a berm after an aborted takeoff. The pilot indicated after liftoff from the runway, the aircraft climbed to 100 feet AGL and began to sink. The pilot then elected to abort the takeoff. The aircraft landed on the departure end of the…NTSB CHI86LA085Accident · No injuriesLimited investigationFinal reportCessna 401B · Milwaukee, WIWhile taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated…NTSB ATL86LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Charleston, SCWhile on a personal cross-country flight the aircraft experienced a complete loss of power and made an emergency landing on a road 2.5 miles east of the airport. The pilot stated that the aircraft ran out of fuel.NTSB ATL86LA071Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Columbia, SCWhile on crosswind following takeoff the engine lost total power after climbing to 500 feet AGL. The pilot initiated a turn toward a field and collided with trees on the approach end of the field. Post-crash examination of the aircraft revealed that the…NTSB ATL86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Alma, GAThe pilot reported that the engine quit during his descent from the 2000 foot cruise altitude. The aircraft examination failed to disclose any system malfunction or failure. The pilot stated that his preflight indicated that there was about 1/2 and 1/3 tanks…NTSB ANC86LA028Accident · Serious injuriesLimited investigationFinal reportCessna 182-A · Merrill Pass, AKThe pilot stated that he could see the whiteout condition ahead. During the 180 deg turn the aircraft struck the 3000 foot level of the mountian Pass. At the time of the accident the weather was a complete IFR whiteout condition.NTSB ANC86LA026Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Mcgrath, AKThe pilot had been drinking for an unknown period before undertaking the night flight. After takeoff, the acft was observed flying in the local area in an erratic manner. Subsequently, the acft crashed about .6 mi short of rwy 16. Impact occurred at the base…