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 ATL85LA183Accident · No injuriesLimited investigationFinal reportHughes 369HS · Aiken, SCDuring a landing, the eng lost power & the helicopter touched down hard. The plt stated that prior to the 15 min flt, the fuel gage was indicating 125 lbs of fuel & at the accident site it indicated 90 lbs of fuel. A post crash inspection of the fuel system…NTSB SEA85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brentwood, CAOn the student plts seventh attempted landing, directional control was lost and a groundloop occurred. The student plt had less than two hours of total pilot in command time.NTSB SEA85LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · North Las Vegas, NVLoss of directional control occurred during the student pilot's second attempted touch and go. The aircraft veered let, struck a berm with the nosewheel and then nosed over. FAA inspectors attempted to physically check flight controls but movement was limited…NTSB NYC85LA140Accident · No injuriesLimited investigationFinal reportCessna 340A · Butler, PAThe plt reported that prior to the flt, he made the usual preflight check & locked the left forward, nose baggage door. During the takeoff roll, the left forward baggage door opened & locked in an upright position. The plt aborted the takeoff, but there was…NTSB CHI85LA225Accident · No injuriesLimited investigationFinal reportCessna 175B · Lancaster, OHThe plt was unaware that the taxiway did not continue to the approach end of rwy 28. He failed to see the turn in the taxiway and the acft continued off the end of the taxiway where it contacted a ditch. The taxiway was not lit (nor was it required to be). It…NTSB CHI85LA222Accident · Minor injuriesLimited investigationFinal reportChadwick Stitts SA-3A · Plymouth, MIThe pilot stated that the takeoff was made at too low an airspeed. The acft continued down the rwy at about 20 ft AGL in a nose high attitude. At the end of the rwy the acft pitched up & nosed over.NTSB CHI85FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech E18S · Cleveland, OHThe flight departed & proceeded en route without incident. Radar & radio contact was maintained until the flt proceeded over lake erie. The flt did not arrive at it's destination. The acft is presumed to have crashed in lake erie. One identifiable 3 ft x 4 ft…NTSB ATL85FA182Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Cartersville, GAThe circumstances & purpose of the flt was not determined. According to witnesses, the owner/student plt & another psn, who was a certified mechanic & an instructor plt, took off & entered what appeared to be a closed traffic pattern for rwy 18. The traffic…NTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…NTSB SEA85LA128Accident · Serious injuriesLimited investigationFinal reportde Havilland DH 82A Tiger Moth · Orland, CAThe plt reported that during a loop, the eng lost power, then the acft entered an inverted spin. He said that he had gotten out of the inverted spin & was recovering from a regular spin when the acft struck the ground. According to a witness, the plt entered…NTSB DEN85LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Kalispell, MTN904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft.NTSB CHI85LA223Accident · No injuriesLimited investigationFinal reportPiper PA-31-T · Rochester, INWhen the plt reduced power & flared, the acft touched down short of the rwy. The acft sustained substanitial damage when the landing gear struck the edge of the raised rwy surface.NTSB ATL85IA180Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA226TC · Cherry Point, NCDuring an appch for ldg at new bern NC, the crew was unable to get the right main ldg gear to extend. Ground observers reported that the right gear door was partially open. The crew elected to divert the commuter air carrier flt. To mcas Cherry Point where…NTSB MKC85FCQ03Accident · 1 fatalFinal reportCessna 172RG · Wichita, KSThe acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter…NTSB FTW85LA246Accident · No injuriesLimited investigationFinal reportCessna A188B · Friona, TXThe plt lost directional control and ground looped off the side of the rwy. The purpose of the flt was to check the adjustment of the acft's spray dispensing equipment. Twenty gallons of water were on board to be used as a substitute for chemical spray. The…NTSB FTW85FA245Accident · 1 fatalField investigationFinal reportCessna 140 · Tioga, TXWitnesses observed the acft apchg from the northwest at an estimated alt of about 100 ft AGL. As it passed their position, the plt rolled into a steep (90 deg) right bank, then roll back out. The witnesses reported that after the acft rolled out of the bank,…NTSB DEN85FTE02Accident · Serious injuriesFinal reportCessna 180K · Atlantic City, WYThe acft nosed over during an attempted landing on a narrow curved roadway in a mining pit. Witnesses reported the acft made a steep descent, touched down on the road and almost immediately departed the road. The acft entered an area of large boulders, nosed…NTSB BFO85FID02Accident · Minor injuriesFinal reportPiper PA-28-R-180 · Brookneal, VAThe acft crash landed in small pine trees during a forced lndg after a pwr loss. The eng quit at 200 ft AGL and the acft crashed 1/2 mile from the end of the takeoff rwy. Investigation revealed a malfunction of the eng fuel pump.NTSB SEA85LA193Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Orovada, NVAfter completing his last spray run, the plt began a turn. During the turn, the eng lost power, then restarted & lost power again. Attempts to restart the eng were to no avail. Since the acft was still at a very low alt (aprx 50 ft), an emerg landing was…NTSB MKC85LA121Accident · No injuriesLimited investigationFinal reportCessna A188B · Marvell, ARPlt stated that the engine stopped producing power after a reduction to cruise power. Touchdown during the forced lanidng was hard. The engine ran satisfactorily during post crash testing and cause of the loss of power could not be determined.NTSB ATL85FA179Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Kennesaw, GAPrior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and…NTSB SEA85LA115Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCB · Yakutat, AKDuring arrival, the plt extended his traffic pattern to allow another acft to depart. He reported that after he turned on final apch, his acft encountered a downdraft & hit the ground short of the rwy.NTSB NYC85LA144Accident · No injuriesLimited investigationFinal reportCessna 305A · Toughkenamon, PAThe acft ground looped during a landing roll on a sod rwy. The plt stated that during the landing roll, it felt as if the right main gear contacted a knoll of grass resulting in the acft ground looping to the right.NTSB NYC85LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Newbury, MAAccording to a passenger, after a long ground roll, the acft lifted off and the plt attempted to increase airspeed by lowering the pitch attitude. As the acft approached the end of the rwy and trees, the stall warning horn sounded. The plt again attempted to…NTSB NYC85FHM01Accident · No injuriesFinal reportSchweizer SGS-1-35 · Middletown, NYThe acft landed off the arpt after the plt lost alt in a spin. The plt was afraid that the glider would land short in trees so he landed on a highway. The hard lndg damaged the acft.NTSB MIA85LA183Accident · Minor injuriesLimited investigationFinal reportCentrair Pegase 101A · Jacksonville, FLThe plt stated that on initial climb, realizing he had no elevator control, released the tow rope than deployed the spoilers and collided with the ground. Post crash examination of the wreckage revealed the elvator cable was not connected.NTSB LAX85LA266Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Hesperia, CAWhile en route, the plt noted thunderstorms & towering cumulus clouds over the tehachapi mountains & elected to divert to Hesperia. He stated that all fields within range had 'severe winds and storms closing.' He said that during the landing at Hesperia,…NTSB FTW85LA242Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · El Paso, TXShortly after liftoff, the plt first smelled, then observed smoke coming into the cockpit from under the instrument panel. Shortly thereafter, the eng quit completely. The plt made a forced landing in an open area off the rwy. During the landing roll, the…NTSB FTW85FA244Accident · 1 fatalField investigationFinal reportCessna 152 · Bogalusa, LAA few minutes after departure the student plt flew into the ground in an effort to return to the arpt about 1400 ft n of rwy 18 in aprx a 15 deg nose down and 35 deg left angle of bank. The afct slid about 80 ft when it rotated about it's right wing flipping…NTSB DEN85LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Cut Bank, MTThe purpose of the flt was to clean the acft spray sys. The plt reported that he initiated a downhill/donwind takeoff in winds that were light, but gusting. At lift-off, the plt lost directional control & the acft mushed & crashed. The plt believed the…NTSB DEN85LA148Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bountiful, UTOn June 1, 1985, an Aeronca 7AC, piloted by a private plt, ground looped while making a touch and go landing at sky park airport, Bountiful, UT. The plt stated that he lost control of the airplane. The winds were reported to be calm.NTSB DEN85LA147Accident · Minor injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Michigan, NDThe plt elected to fly the newly purchased acft around the airstrip to test the spray sys. Shortly after taking off, the eng stopped running while the acft was over a slough. The plt was unable to glide the acft to suitable terrain, & subsequently, the acft…NTSB CHI85LA224Accident · No injuriesLimited investigationFinal reportStearman E-75 · Lake Odessa, MIUpon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed…NTSB CHI85LA220Accident · No injuriesLimited investigationFinal reportCessna 150H · Montevideo, MNThe purpose of the flt was to demonstrate the acft to a possible buyer. While taking off, the eng lost power shortly after the acft lifted off at about mid-field. The plt attempted to turn the acft & land on a cross-runway. However, due to his low speed & low…NTSB BFO85IA050Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30F · Chantilly, VAAfter climbing up to and leveling off at 37,000 feet, the crew of the DC-10-30F noticed that the york control of the captain and the first officer moved laterally independently of each other for approximately two inches. After making an unscheduled uneventful…NTSB ATL85LA178Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSPlt was returning to arpt with known low fuel state. The planned landing was to be on rwy 18 but while approaching the arpt, the eng missed. The plt elected to land on rwy 36 with a tailwind and conflicting traffic. The conflicting traffic cleared the rwy and…NTSB ANC85LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe acft sustained substantial damage when the pilot lost control of the acft and nosed over on its back. The weather was VMC but the pilot said he encountered a gust and crosswind during landing.NTSB NYC85FNA01Accident · Serious injuriesFinal reportGulfstream AA-5B · Boxborough, MAThe pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.NTSB MKC85LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concordia, KSThe student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran…NTSB MKC85FA120Accident · 2 fatalField investigationFinal reportCessna 152 · Albert, KSWhile maneuvering to reverse directions the acft stalled descending and impacting the ground in a steep dive. The plt was on the final leg of his cross-country flt.NTSB FTW85LA252Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAThe left brake failed during the landing roll. The acft veered to the right of the rwy and ground looped. During the groundloop, the left tire blew and the tail wheel spring bolt assembly failed. Cause of the brake failure was not determined.NTSB FTW85LA243Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Edna, TXThe pilot lost directional control during a crosswind takeoff from a ranch road. The acft veered off the right (north) side of the road where it contacted a ditch in a rice field.NTSB FTW85LA240Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Hillsboro, TXThe pilot had just taken off on runway 16 at the municipal airport in Hillsboro, TX. This wind, as reported by the pilotwas 220 degrees at 16 knots with gusts to 22 knots and the temperature was 102 degrees. Two persons and 16 gallons of fuel were aboard.…NTSB FTW85FPA03Accident · No injuriesFinal reportMooney M20 · Fort Worth, TXThe acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating…NTSB DEN85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-25-260-C · Ordway, COThe airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the…NTSB DEN85LA145Accident · No injuriesLimited investigationFinal reportCessna 182 · Byers, COPlt stated that he was 'in a rush to get home' after his extended trip. He continued to state 'I wanted to get home thatafternoon without another stop and I wanted the performance figures to show me that I could.' The plt executed an emerg landing after the…NTSB CHI85LA219Accident · No injuriesLimited investigationFinal reportCessna T210 · Marion, INShortly after takeoff, the plt discovered that the elevator controls were jammed & pitch changes could only be made with elevator trim & power. An emerg landing was made using the trim, but the plt was unable to flare the acft at landing speed. The acft…NTSB ATL85MA177Accident · 2 fatalMajor investigationFinal reportGulfstream G-159 · Nashville, TNThe acft was being operated as general aviation flt 115 & was deptg on a routine night flt. Drg takeoff/initial climb, the left eng lost pwr. The flt crew attempted to cont the climb-out, but following the application of water-methanol, the plt lost drctnl…NTSB ANC85LA088Accident · No injuriesLimited investigationFinal reportCessna A185F · Alaktak, AKThe acft collideded with a snow bank and nosed over during a landing attempt on a frozen lake. The plt stated that 'my rt ski hit a pressure ridge or broke through crust; whichever, the acft abrurtly pitched down, contacting the ice and continuing over onto…NTSB SEA85LA126Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Athena, ORThe acft settled back to the ground shortly after takeoff before achieving translatioanal lift. The plt was attempting to test a new spray unit that had been installed. He had put 80 gallons of water in the spray tanks.