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 LAX85LA182Accident · 2 fatalLimited investigationFinal reportCessna P210N · Mountain Pass, CAThe non-instrument rated plt departed into a weather front. VFR flt was not recommended. Flt precautions existed for icing, turbulence & mt obscuration. The radar chart showed light to moderate rain with isolated thunderstorms. The acft was issued a clearance…NTSB LAX85FA179Accident · 1 fatalField investigationFinal reportStracener Experimental SX · Fremont, CAThe acft was being leased to the atr plt by the registered owner. This was the plt's first flt in the acft. Weather conditions were conducive for carburetor icing. Just prior to takeoff the owner advised the plt that the acft was equipped with a low pressure…NTSB FTW85LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Wheeler, TXAccording to the plt, en route deteriorating wx was experienced and he elected to land at Wheeler instead of his original dest, grandfield, OK. The acft was landed slightly fast and downwind. Winds were from 210 degrees at 15 gusting to 20. At the acft neared…NTSB FTW85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Justin, TXThe purpose of the flt was a mult-engine flt check given by a designated examiner to the commercial plt. According to the examiner the right eng, which was still hot from the previous flt, would not start on the first attempt. After a successful start of the…NTSB FTW85LA155Accident · No injuriesLimited investigationFinal reportCessna 177 · Monroe, LAAprx 15 mins after departure, on final apch to Monroe regional arpt the eng lost pwr due to fuel exhaustion. During the forced landing the acft struck cable tv lines and trees causing a right yaw and uncontrolled descent to the ground. The student plt stated…NTSB DEN85LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Wesbter, SDThe student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…NTSB NYC85FA083Accident · 1 fatalField investigationFinal reportCessna 401A · Dorset, VTThe plt was about 30 miles from rutland when he radioed the arpt for weather info. He was informed that clouds were 1500 ft broken and 2700 ft overcast with snow, light fog and 5 miles visibility. The plt responded that he would call again when he got closer…NTSB MKC85LA073Accident · No injuriesLimited investigationFinal reportCessna T210M · Joplin, MOThe acft nose gear collapsed after a hard bounced landing. The plt stated that she touched down hard on the main gear then bounced and relanded on main and nose gear. During the 2nd touchdown the nose gear collapsed. The plt and her one-year-old daughter were…NTSB LAX85FA178Accident · 1 fatalField investigationFinal reportCessna 150F · Lee Vining, CAThe acft collided below the crest of an 8100 ft (MSL) mtn on a flt from mammoth-june lakes arpt (mmh), mammoth, CA, to reno, NV, while executing a left turn course reversal. There were no witnesses to the accident. Witnesses reported seeing the acft flying at…NTSB DEN85FTI03Accident · No injuriesFinal reportHilliard B-8-M · Clinton, MTThe gyrocopter inadvertently became airborne during a high speed taxi run. The plt reported that at an alt of aprx 10-15 ft AGL he 'cut the engine speed to idle, and pulled the joystick fully back to land.' This action put the gyrocopter in a nose high…NTSB CHI85LA144Accident · No injuriesLimited investigationFinal reportChampion 7EC · Lake Elmo, MNOn takeoff, at about 150 ft AGL, all power was lost and the pilot executed a forced landing on the airport. Post-accident inspection revealed contamination in the fuel manifold valve.NTSB CHI85LA141Accident · No injuriesLimited investigationFinal reportCessna T210L · Sauk Village, ILDuring a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.…NTSB SEA85LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Dufur, ORA loss of power occurred during aerial application and a forced landing was made onto a field. The right main gear sank into a hole and was torn off. The acft then flipped inverted. The throttle leakage was found to be broken.NTSB MIA85LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Pine Key, FLThe plt stated that while in cruise flt at about 1200 ft & 2300 RPM the eng lost pwr & the acft was ditched aprx 100 yards off shore in the ocean waters. The acft was found to have sufficient fuel in both tanks. The fuel selector was on, the fuel screen was…NTSB MIA85FA123Accident · 2 fatalField investigationFinal reportAronson Falco F8L · Gainesville, FLThe plt received a wx briefing & filed an IFR clnc, then departed VFR. Except for a hdwnd, the 1st part of the flt was normal. In the vcnty of macon, GA, the plt requested & received an IFR clnc. Later, he elected to divert to the gaines- ville rgnl arpt &…NTSB LAX85LA177Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Byron, CAThe CFI & student plt were practicing takeoffs & landings. During the students second apch, the acft was too high & fast. The acft touched down midfield, left of the rwy, & in the grass. The CFI applied pwr to takeoff, however, the acft stalled and the left…NTSB FTW85LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Athens, TXThe acft contacted trees and descended uncontrolled into the terrain during an initial takeoff climb. The takeoff was made on a 1830 ft sod strip which is bordered on the departure end by trees. The plt stated he used full throttle (2400-2450 RPM) but only…NTSB FTW85LA153Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Arlington, TXAccording to the passenger, a gust of wind caused the Balloon to become airborne prematurely and drift toward pwr lines. Aprx 25 ft from the wires the plt attempted to abort the takeoff by deflating the envelope. Just prior to wire contact the passenger…NTSB FTW85LA151Accident · Minor injuriesLimited investigationFinal reportDouglas A-26B · Lawton, OKAn intermittant fire in the left engine accessory section led to loss of fuel to the engine. The right engine injested water and quit. The landing gear had been left pinned in the down position because of a malfunction reported on the previous flight. Neither…NTSB FTW85FA152Accident · 1 fatalField investigationFinal reportUniversal Stinson 108 · Emhouse, TXWitnesses observed the student plt making repeated low passes near his friend's house. While maneuvering, the acft collided with a power line, then crashed to the ground inverted. The student held a student plt certificate that was dated 10/17/62. No record…NTSB CHI85LA142Accident · No injuriesLimited investigationFinal reportCessna 172RG · Portland, INUpon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the…NTSB NYC85LA084Accident · No injuriesLimited investigationFinal reportCessna 172P · Princeton, NJThe acft experienced nose gear damage following a loss of control during touchdown. The plt stated the acft touched down on the main gear and bounced as the nose gear was being lowered. After the acft porpoised several times the plt was able to regain control…NTSB MIA85FA122Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Winter Haven, FLWhile taxiing back to the seaplane ramp after landing the acft struck a small fishing boat causing fatal injuries to the boats sole occupant. The acft was being taxied at high speed on the step and s turns where being made to clear the area due to the plt not…NTSB LAX85LA183Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Apple Valley, CAUpon landing & taxiing off the rwy the ATP certificated plt was unable to locate the desired acft hangar in which the acft was to be parked. The plt & his 15-year-OLD pax observed a bystander near their acft. The plt directed the pax to exit the acft & ask…NTSB LAX85LA176Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Paso Robles, CAThe plt pulled the prop through by hand after attempts to start the acft failed. The unoccupied acft started and traveled aprx 200 ft before contacting the left wing of another acft. Inspection revealed the 'p' lead on the left magneto was not grounded. The…NTSB LAX85IA175Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · San Jose, CAA Piper seminule was vectored to the final apch course & cleared for an ILS apch at 3000FT MSL. A DC-9, in trail at 5000FT MSL, was overtaking the seminule. The controller elected to change their sequence & cleared the seminule to climb to 4000FT MSL due to…NTSB BFO85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150H · South Hill, VAWhile on a solo cross country flight the student pilot became disorientated after about 60MIN of flt. He atmptd to call in the blind on guard. Freq. Both danville and roanok fss's responded to his calls but were unable to establish 2 way commo with the plt.…NTSB BFO85LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Leesburg, VAThe plt enplaned 3 adult paxs and taxied to rwy 17 for tkof. Rptd wnd was 310 at 8KTS. Tkof roll was iniated and continued until near midfld at which time it became apparent to the plt that the acft would not rotate. The plt then abtd the tkof but as the acft…NTSB ATL85LA121Accident · Minor injuriesLimited investigationFinal reportBell 47G · Erin, TNAfter a power loss at low alt. During approach to touchdown,the pilot bled off rotor RPM attempting to clear power lines across his approach path. This resulted in a lack of rotor energy necessary for an autorotaiton landing. A hard landing resulted.…NTSB ATL85LA120Accident · No injuriesLimited investigationFinal reportCessna 411 · Mobile, ALThe acft experienced a ttl electrical failure for unknown reasons. The plt descended and flew below low ceilings until and arpt was found. Attempts to lower the landing gear with the emerg hand crank failed. Low on fuel, he landed with gear up. The plt…NTSB ATL85LA119Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Tarboro, NCThe plt was attempting a simulated emergency landing on an ag airstrip & collided with several unmarked power lines while on final approach. The student plt was not authorized to land at the ag strip according to his flight instructor.NTSB SEA85LA076Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Davenport, WAA vibration started in the engine and while the plt was monitoring the engine gauges he noted a loss of all oil pressure. A landing was made on a field and during rollout the left main gear was torn off when it struck a mound of dirt. The acft then struck…NTSB SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.NTSB MKC85LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Anton Chico, NMPilot stated that he was on a VFR no-flight-plan-flight from meade, KS, to alburquerque, NM, when he saw a cloud bank ahead. While diverting around, he flew into haze that became clouds. Recovery from strong down and up drafts did substantial damage to wings,…NTSB MKC85LA072Accident · No injuriesLimited investigationFinal reportHughes 369HS · Princeton, MOThe helicopters tail rotor collided with power lines during an apch to an open field. According to the plt, upon descending onto the fld, the acft began to vibrate severely. Consequently, the plt lost control and the helicopter made two 360 degree revolutions…NTSB MIA85IA120Incident · No injuriesIncident investigationFinal reportDouglas DC-6B · Miami, FLCrew stated that on takeoff roll the number four engine failed and an aborted takeoff was intiated. During the decelleration after the throttles were closed the number four engine seized and the number four propeller separated when the propeller shaft failed.…NTSB LAX85LA174Accident · No injuriesLimited investigationFinal reportEngel Engel AIR · Truckee, CAPlt built this acft and this was the 4th test flight. Plt was lined up on rwy 28 for takeoff. Upon rolling lift off plt lost directional control and ran into a tall snow bank.NTSB LAX85LA173Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Scottsdale, AZThe plt & pax departed phoenix sky harbor on a sales demo flt & landed nearby at falcon fld. During the return flt, the eng lost power as the plt began descending from 3800'. He noted there was no fuel flow, so he used the wobble pump. The plt said he was…NTSB FTW85LA150Accident · No injuriesLimited investigationFinal reportCessna 305E · Mckinney, TXThe engine quit shortly after takeoff. The pilot landed in soft terrain (muddy field) and the aircraft nosed over. The pilot reported finding 1/2 cup of water in the fuel tank and gascolator.NTSB DEN85FA097Accident · 1 fatalField investigationFinal reportMooney M20F · Deming, NMDuring preflt & inflt wx briefings, the plt was advised that mountains along his route were obscured by clouds & precip. Also, he was cautioned about moderate icing in clouds & precip at or above the freezing lvl. While en route, the plt obtained clearance to…NTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…NTSB ANC85LA059Accident · No injuriesLimited investigationFinal reportBell 206B · Mcknley Park, AKDuring takeoff the helicopter contacted a .081 inch copper wire which was strung across the river at an alt of aprx 15 ft. the wire became entangled in the tail rotor resulting in control difficulties, however, the plt was able to land the helicopter aprx 1/2…NTSB SEA85LA074Accident · No injuriesLimited investigationFinal reportGrumman 164A · Ritzville, WADuring landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver.NTSB MKC85LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwalk, IAApproaching des moines airport the plt rptd to approach control of eng problems and wanted to know what airport was close for an precautionary landing. An attempt was made to land at an airstrip 3 mi east of his present posn. Unable to land at the airstrip…NTSB MIA85LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe acft collided with trees while the plt was practicing slow flt on a solo training flt. The plt stated after the accident that he diverted his attention from outside to the acft instrument panel and felt a jolt. A full pwr recovery to level flt was made…NTSB MIA85LA119Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sugar Loaf Key, FLThe engine failed just after takeoff and the acft landed in a field north of the arpt, collided with trees and nosed over. Post accident examination of the fuel system shows that the acft micron fuel filter was contaminated to the extent that it caused…NTSB MIA85LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Zephyrhills, FLThe plt stated that he experienced a complete loss of power & upon making his emerg landing in a pasture, the acft struck fence posts, separating the right main landing gear. Investigation of the fuel system revealed there was no fuel in the left tank &…NTSB LAX85LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAccording to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also…NTSB DEN85LA095Accident · No injuriesLimited investigationFinal reportCessna 310 · Angel Fire, NMThe acft touched down 1500 ft short of the rwy and the nose gear collapsed. The taxiways were rough and soft yellow chevrons were painted on the taxiways, at the apch end of the rwy. The plt stated that he was concentrating on the apch and did not see the…NTSB DEN85LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28L · Salt Lake City, UTThe acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…