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 LAX85LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe plt landed normally & taxied off the rwy. The acft encountered a gust of wind & nosed over. Winds were reported as 300 deg at 20 KTS gusting to 25 KTS.NTSB LAX85FA070Accident · 3 fatalField investigationFinal reportCessna R172K · Desert Center, CAThe flight departed on an IFR flight after receiving a weather briefing which included flight precautions for light to moderate icing in clouds and in precipitation from 7,000 ft to 20,000 ft. the pilot reported picking up ice and that he was unable to climb…NTSB FTW85LA077Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXAn experienced professional pilot encountered forecast icing conditions on approach that obscurred forward visibility. On go-around, anti-icing equipment cleared small area of windshield, pilot decided to land. He failed to maintain sufficient airspeed to…NTSB FTW85LA075Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Temple, TXDuring the flt in IMC, plt reported low oil pressure to ATC and declared an emergency. Aprx 4 mins later an engine failure was experienced. Plt stated he broke out of the overcast at aprx 250 ft AGL and the acft impacted a power line during the attempted…NTSB ATL85FA055Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burlington, KYAcft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded…NTSB SEA85FA035Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601A · Genoa, NVThe plt had flown from carson city, NV to shreveport, la on 12/10/84 for business. At 1530 on 12/12/84, he departed on aflt to corona,CA with refueling stops at albuquerque, NM & phoenix, AZ. He departed phoenix at 2100, but encountered wx & returned to…NTSB MIA85FA059Accident · No injuriesField investigationFinal reportBritten-Norman BN-2 · San Juan, PRAfter landing the flt was directed by ground control to taxi to the cargo ramp making room for a taxiing Boeing 747. Ground control then asked the acft to make a 180 deg turn and taxi further east on the ramp. As the left turn was completed the right brake…NTSB MIA85FA058Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Miami, FLPlt judged by reference to acft gages that he had 156 gals of fuel remaining when infact only 120 gals of fuel remained. On approach for lndg, while operating on aux tanks, low fuel flow warning light illuminated. Plt switched to main tanks and both engines…NTSB LAX85FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Gorman, CAThe plt was on a night x-country flt. When the acft did not arrive at its destination, a search was initiated. On 12/12/84, the plane was found where it had impacted an area of rising terrain while approaching the tehachapi mountains. Impact occurred on a…NTSB LAX85FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Rosamond, CAAcft crashed in mountainous area while on a VFR flight. No record of the plt obtaining a wx briefing was found. Local residents 3-4 miles from accident site reported clouds, fog, rain, snow and hail obscured the mountains on the afternoon of 12/12/84 on…NTSB LAX85FA068Accident · 1 fatalField investigationFinal reportHart-Thorp T-18 Tiger · Tulare, CAAcft departed arpt & about 5 mins later was seen 'descending vertically' out of 'dark rain cloud' at about 1,000 ft AGL. During attempted recovery at about 300 ft AGL, acft broke up & crashed in a field. Plt did not obtain wx briefing prior to flt and did not…NTSB DEN85LA042Accident · No injuriesLimited investigationFinal reportHughes 369D · Springville, UTThe acft was being positioned at a remote site for a passenger pick-up. During the maneuvering to get into a good spot for landing the plt lost visual reference because of blowing snow. The plt said he felt the right skid hit the ground and lowered collective…NTSB DEN85LA041Accident · No injuriesLimited investigationFinal reportGulfstream Aerocommander 695 · Cortez, COThe accident acft was the first to use the rwy since it was scraped by the snow plow earlier in the day. A commercial plt that operates at the arpt said about 2-3 inches of snow had accumulated on the rwy since it was cleared. The plt of the accident acft…NTSB ATL85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Albermarle, NCPlt saw unfamiliar mountain range and decided to land in a residential construction site to find out his exact location. Plt failed to see electrical wires during the descent until too late. Plt lost control of acft in last minute attempt to avoid wires. Acft…NTSB ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…NTSB NYC85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T337G · Lawrence, MAN8CF made an emergency landing in a wooded are after experiencing a dual engine failure aprx 50 minutes after takeoff./ the fuel pressure gage for the front engine displayed erratic elevated readings. The pilot then decided to return to the departure airport…NTSB NYC85IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYDuring taxi for departure, acft experienced several jolts to the right. Capt stopped acft and requested grnd personnel to inspect landing gear. Inspection revealed rt main gear truck beam failed. Metallurgical inspection of truck beam ass'y concluded the…NTSB LAX85FA067Accident · Serious injuriesField investigationFinal reportBeech G35 · Lakeport, CAAt aprx 150 ft AGL the acft's lost pwr & plt made a tail first hard landing off side of rwy. Acft skidded 60 ft before stopping when it hit a fence. Fuel selector was found in 'aux' position. Plt said he took off on left tank and was moving selector to rt…NTSB DEN85LTE03Accident · 1 fatalFinal reportKenneth Roebuck Varieze · Antonio, COPlt had filed a VFR flt plan from espanola, NM, to durango, CO, with a proposed departure time of 1500 MST and as en route flt time of 1 hr 10 mins. The flt plan was not activated. A search for the acft began on 12/13/84 and ended on 12/24/84. On 6/10/85 the…NTSB CHI85FA070Accident · 2 fatalField investigationFinal reportPiper PA-31 · Pontiac, MIThe aircraft departed the airport with one dry air pump inoperative and the other pump reading low. Aircraft control was lost during an instrument approach in IMC approximately 2.5 hours later. Both pump driveshafts were found sheared in the wreckage and both…NTSB SEA85FA030Accident · 2 fatalField investigationFinal reportCessna C-152 · Port Orchard, WALow ceilings, rain, fog were reported in area pt the time of the accident. The student pilot was on a solo x-c, flt plan was filed with help of instru. Wx VFR nr. Acft dep 1104 PST acft crashed abt 1317 no rcrd of des reached or where acft was for 2 hrs. Acft…NTSB MKC85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Norfolk, NEThe plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…NTSB MKC85LA034Accident · No injuriesLimited investigationFinal reportCessna R172K · Almyra, ARCrossing over a road the pilot saw a friend's car and elected to turn around and fly back over the road. During the descending right turn, while looking at the vehicle on the road, the acft flew into the ground.NTSB LAX85LA090Accident · No injuriesLimited investigationFinal reportBeech C45H · Littlefield, AZThe plt stated that he encountered low ceilings & fog in the mountain passes. After several unsuccessful attempts to cross the mountains he believed he did not have sufficient fuel on board to reach any airports to the south so he selected a flat mesa &…NTSB LAX85FA066Accident · 1 fatalField investigationFinal reportBarry Zielinski SNS 8 Hiperlt · Corona, CAN5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar…NTSB CHI85LA069Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Columbus, OHThe plt reported that he did not have the acft refueled prior to departure & once airborne encountered a stronger head wind than anticipated. He stated that most of the possible en route fuel stops were 'down due to fog.' When aprx 18 mi past port Columbus…NTSB SEA85LA029Accident · No injuriesLimited investigationFinal reportCessna 172M · Sultan, WAAn overrun occurred on the 2,000 foot airstrip due to excess approach and landing speed. A light coating of snow was present on the grass runway and the pilot neglected to raise the flaps adding to a longer landing roll and making braking less effective. A 5…NTSB NYC85LA040Accident · No injuriesLimited investigationFinal reportBeech 58TC · Norwood, MATouchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an…NTSB MIA85LA056Accident · No injuriesLimited investigationFinal reportSikorsky UH34J · Carrabelle, FLThe acft was conducting external load logging operations in a hover at aprx 175 ft AGL when the power loss occurred. According to the plt, the eng ran intermittently with black smoke coming out of the exhaust pipe before the eng failed totally. The…NTSB MIA85FA057Accident · No injuriesField investigationFinal reportBeech 65 · Marathon, FLAccording to the plt, aprx 20 min after departure at 4,000 to 5,000 ft the left eng failed followed 10 min later by a power loss in the right eng. During the desc the right eng restarted momentarily but only ran for about 1 min. The plt ditched near a…NTSB FTW85LA073Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe acft experienced a power failure while in cruise flight at 1100 ft AGL. He stated that after switching tanks, the 'engine started twice bit failed to continue'. Investigation revealed that the left fuel tank was empty and the right tank had an…NTSB ATL85LA052Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Griffin, GAThe acft crashed during an emergency landing while on a personal x-counry flight. Inspection of the acft at the accident site revealed empty fuel sumps and fuel tanks.NTSB ANC85FA027Accident · No injuriesField investigationFinal reportCessna 140 · Wasilla, AKOn go-around during a simulated forced landing over a dirt landing strip engine began to sputter and run rough. Plt stated power was reduced and engine began to run smooth. Fuel tank was switched and 15 to 20 seconds later, engine quit. Forced landing was…NTSB SEA85FA028Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Gig Harbor, WAThe plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were…NTSB MIA85LA055Accident · No injuriesLimited investigationFinal reportCessna 150F · Fort Myers, FLThe plt was practicing touch and go landings. On the accident landing the acft drifted to the rt of the rwy and touched down with a side angle. The plt said the acft ballooned and he applied power to go around but thought he did not have the proper control so…NTSB MIA85LA054Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Daytona Beach, FLPlt stated that he was unfamiliar with the arpt and requested assistance to taxi to the ramp. The pilot was told to take the first left turn to ramp, he turned onto an access road to the fire station and collided with a sign that stated 'no taxiway.'NTSB LAX85LA064Accident · No injuriesLimited investigationFinal reportBeech B-60 · Van Nuys, CADuring landing roll out the plt observed the acft's nose gear begin to collapse. Although on approach the plt had placed the ldg gear selector in the down position & had observed the illumination of the green gear down lights, the plt responded to the…NTSB DEN85LA039Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Conrad, MTPlt stated takeoff was being made on a dirt trail, heading 270 degrees, with a 20 kt headwind. Just prior to rotation wind shifted to a direction from the south-southwest. Acft drifted off right side of trail, contacted a ditch and nosed over.NTSB DEN85FA037Accident · 1 fatalField investigationFinal reportCessna T-210G · Meeker, COThe a/c dept larami, WY on an IFR flt to grand junction, CO.in the vicinity of Meeker, CO, the plt experienced an apparent instrument gyro problem. He flew off course once but with the help of ARTCC he was vectored back on course, only to again go off crse,…NTSB CHI85LA065Accident · No injuriesLimited investigationFinal reportCessna 150C · Hampshire, ILTouchdown occurred nearly half-way down airstrip, which was wet with melting frost. Plt did not attempt a go-around, but relied on braking action for safe completion of landing roll. Braking action was nil. Acft overran through a barbed-wire fence and into a…NTSB CHI85FA067Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Albion, INCarburetor icing conditions existed on the day of the accident. The plt stated that after takeoff, he stayed in the traffic pattern to ensure he would not experience carburetor icing problems. He then departed the traffic pattern & overflew a wooded area…NTSB BFO85FA008Accident · No injuriesField investigationFinal reportBeech C23 · Clifton, VAShortly after leveling at the cruise altitude of 2500 ft, the pilot noted a gradual RPM decrease and resultant loss of power. Altitude could not be maintained and the pilot selected a rolling open field in which to land when he realized that reaching an…NTSB ATL85LA051Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fremont, NCThe student plt reported that he landed hard & bounced twice before settling to the rwy. He applied full braking & the acft skidded off the end of the rwy.NTSB ATL85FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman American AA-5 · Dayton, OHAircraft missing on a flight from Dayton, OH to gallipolis, OH two persons on board.NTSB NYC85FA039Accident · 1 fatalField investigationFinal reportMooney M20J · Montague, NJThe pilot of this aircraft was discharged from the hospital following a bladder biopsy about six hours prior to the accident. Although he was advised not to fly that day he elected to do so. He was engaged in buzzing a friends house when he collided with…NTSB MKC85LA033Accident · No injuriesLimited investigationFinal reportRockwell S-2R · West Helena, AROn departing West Helena arpt the plt reduced pwr to a cruise pwr setting. The engine responded to the pwr reduction but then the torque dropped to zero. The acft descended striking the ground. Inspection and testing of the engine and fuel control unit did…NTSB LAX85LA063Accident · No injuriesLimited investigationFinal reportHughes 269C · Boulevard, CAPlt was executing low level photographic survey of valleys in mountainous terrain. Acft entered a narrow valley with steeply rising terrain ahead. When plt realized excessive rate of climb would be required to clear obstacles, he attempted a steep turn-around…NTSB FTW85LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Slidell, LAWhen the renter plt arrived at the fixed base operator, he was informed that his acft had been flown 1.6 hrs and had not been refueled. Further, he was told that the acft was booked by another plt in one hr. Plt elected to take the acft with partial fuel…NTSB DEN85LA038Accident · No injuriesLimited investigationFinal reportHughes 369D · Spanish Fork, UTShortly after takeoff plt felt shutter in acft and noticed a rise in the turbine outlet temp. Plt heard low whine of high pitch noise in engine. Engine chip detector light came on followed by the engine out light and horn and oil pressure warning light.…NTSB CHI85LA066Accident · No injuriesLimited investigationFinal reportCessna 177 · Cadiz, OHThe acft was damaged during a forced landing after the eng failed inflight. The plt stated that about 10 miles west of harrison airport the eng began sputtering & running rough. When unable to regain full power the plt attempted to glide to tapan airpark, a…