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 DCA85IA019Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Detroit, MIThe flt crewmembers of the jumbo jet were preparing to start the engs when flt attendants (f/a's) in the forward cabin detected a faint odor prior to closing door 1L. The source could not be determined, so the door was closed in preparation for a pushback.…NTSB BFO85LA040Accident · No injuriesLimited investigationFinal reportBeech E18S · Fishersville, VAWeather conditions in charlottesville, Virginia, the intended destination, resulted in a missed approach and diversion to shenandoah valley airport, where two more missed approaches were executed. On the climb out from the second missed approach, the left…NTSB ATL85LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Hilton Head, SCThe plt stated that the landing gear selector was placed in the down position while on downwind for ldg & upon touchdown the landing gear collapsed. Post crash examination of the landing gear failed to disclose any mechanical failure or malfunction of the…NTSB ANC85FA070Accident · No injuriesField investigationFinal reportCessna 336 · Anchorage, AKWitness near the crash site stated that both aircraft engines were stopped prior to the accident. The plt reported that before taking off, the fuel quantity gages indicated there was sufficient fuel for the flight, the plt did not preflightthe aircraft.…NTSB MIA85LA157Accident · No injuriesLimited investigationFinal reportCessna T310R · Boca Raton, FLThe plt stated that while taxiing in from landing & upon exicuting a right turn into the ramp the right main landing gear collapsed. Inspection of the landing gear revealed that the aft push pull retract rod failed at the rod end allowing the collapse of the…NTSB MIA85IA156Incident · No injuriesIncident investigationFinal reportRockwell AC-500 · Palm Beach, FLOn final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was…NTSB MIA85IA155Incident · Minor injuriesIncident investigationFinal reportGrumman G-73-T · St. CroixWhile on an FAA observed proving flight, water take off, the left propeller electrical terminal failed. The part then penetrated the left forward passenger window and struck the FAA observer causing minor injury. The plastic part failed in over load due to…NTSB MIA85FLD01Accident · Serious injuriesFinal reportCessna 172B · Brooksville, FLAccording to a plt statement, he entered the traffic pattern at about 800 ft & held 70 mph with 10 deg of flaps & the carb heat on. After turning onto final apch, he advanced the throttle for a power adjustment, but the eng did not respond. Subsequently, the…NTSB LAX85LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA32-301T · Show Low, AZAfter giving the pilot airport advisories,via UNICOM, the refueler drove the refueling truck across the runway in front of the aircraft during its takeoff roll. The pilot unable to stop before impact, attempted to takeoff before reaching the tanker. The…NTSB LAX85FUG03Accident · Serious injuriesFinal reportVickers Slingsby T56A Vega · Hemet, CAThe sailplane was in level flt when the plt felt flutter and lost pitch control of the acft. After one uncontrolled loop the plt bailed out and received serioud injuries during the parachute landing. Loss of all six elevator hinges had caused the elevator to…NTSB ANC85LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga, AKThe plt stated that the right ski hit something during the takeoff run & bent the right main gear/ski down & aft. He elected to land on snow covered terrain near the small village of Beluga, AK. Before coming to rest during the landing, the acft went over on…NTSB NYC85FFA02Accident · Serious injuriesFinal reportCessna 177 · Claryville, NYThe acft impacted trees during a precautionary lndg due to the plts EST of a low fuel state. The flt had proceeded r enroute to an intended dest of oxford me from frederick MD without filling a flt plan. After aprx 3 hrs of flying on a 60 degree mag hdg the…NTSB CHI85LA175Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Richfield, OHThe plt made a short field takeoff using aprx 1700 ft of the 2200 ft airstrip. Unable to clear trees along the flt path, he turned to the right. However, the acft's wheel pants contacted a tree while the plane was still banked to the right & a slight amount…NTSB CHI85FA174Accident · Serious injuriesField investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircraft was paralleling a line of thunderstorms and needed to get on the other side of the line to get to his destination. The center controller suggested that he reverse course to fly around the closer end of the line but the pilot decided to penetrate…NTSB ATL85FA146Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dundee, MSPlt obtained three preflight wx briefings then filed IFR using an assumed name. Routine communications until 2117 CST when pilot reported in a cell and said he wanted to make a 180 degree turn. Cleared for right turn. Radar and comm contact with aircraft lost…NTSB SEA85LA095Accident · 2 fatalLimited investigationFinal reportBeech 36 · Elko, NVElko DME (located at the arpt, used for the lda/dme apch, 108.5 mhz) was inop. Drg arrival, the plt expressed mistrust of his DME. Aprx 24 mi sse of bullion (bqu) VOR, ARTCC controller (ctlr) clrd N7514N for 'the apch to the Elko arpt.' Seconds later, the plt…NTSB MKC85FA088Accident · 2 fatalField investigationFinal reportCessna 310G · Mena, ARThe acft crashed out of control after an in-flt airframe failure. The plt had entered an area of thunderstorms after being advised that VFR flt was not recommended in that area. The plt was single eng rated and his flt time in this z eng acft was 18 hrs.NTSB MIA85LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Ocala, FLThe plt stated that during the landing flare, he stalled the acft & landed hard.NTSB MIA85LA154Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Myers, FLPlt stated that on takeoff ground run from a turf runway he felt severe vibration in the nose gear and lifted it off the ground. As he did he thought he felt a loss of engine power an aborted the takeoff. Before the aircraft could be stopped it overran the…NTSB LAX85FA214Accident · 1 fatalField investigationFinal reportBeech A45 · Fallbrook, CAThe plt was flying to his home arpt under visual flight rules (VFR) from his place of employment when he encountered low ceilings & visibilities. He contd at low alt along an interstate highway toward his original destination. A witness reported that the plt…NTSB FTW85LA194Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sallisaw, OKAn annual inspn had just been completed (4/22/85) & each eng had about 1 hr of flt time. The plt stated that he took off & climbed to cruise at 9000 ft, then closed the cowl flaps & set the fuel settings for 75% power. While en route, he noted oil trailing…NTSB FTW85LA192Accident · No injuriesLimited investigationFinal reportCessna 150 · Abilene, TXThe plt had little recent tail wheel experience. The accident occurred while landing in a x-wind that exceeded either or both the acft's and plt's capabilities. The acft ground looped. The left wheel dropped into mud beside the rwy and separated. The main…NTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…NTSB CHI85LA173Accident · No injuriesLimited investigationFinal reportCessna 172M · Macedonia, OHWhile cruising at 2500 ft MSL, the eng developed a severe vibration accompanied by a partial pwr loss. The plt made a forced landing uphill on an inclined field. He initiated a sharp left turn to avoid a house. At that time, the nose gearcollapsed & the acft…NTSB ANC85LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKThe plt stated that the acft encountered a downdraft while he was on final apch for a touch-&-go landing. Subsequently, the acft touched down in wet snow about 30 yards short of the rwy & nosed over. The plt estimated the wind was from 010 deg at 5 KTS.NTSB ANC85LA068Accident · No injuriesLimited investigationFinal reportCessna A152AEROBAT · Whittier, AKThe pilot in command failed to perform an adequate reconnaisance of the airport prior to landing and did not avail himself of all information concerning the runway conditions.NTSB SEA85LA094Accident · No injuriesLimited investigationFinal reportHelio H-295 · John Day, ORReportedly, the acft encountered airframe icing conditions during flt, & subsequently, mushed into trees on wooded terrain. Elevation of the crash site was about 4500 ft. about 95 mi west at redmond, OR, the wx was in part: 800 ft overcast, 3 mi visibility,…NTSB NYC85FA110Accident · 2 fatalField investigationFinal reportCessna R182 · Hamilton Twnshp, NJThe plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared…NTSB LAX85LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Boron, CAWhile on a cross country business flt, the plt said he became concerned about an indicated low fuel state and decided to make a precautionary landing. Two approaches had to be abandoned due to what the plt described as 'the most difficult x-wind conditions…NTSB LAX85FA218Accident · 2 fatalField investigationFinal reportCessna 152 · Sunland, CAThe plt got his pvt plt cert 6 days prior to the accident & planned a local flt to a neighboring arpt just over a coastal mtn range from the dep aprt. 9 NM north of the deparpt, the accident site is almost on a direct line between the dep & dest arpts. The…NTSB LAX85FA215Accident · 5 fatalField investigationFinal reportPiper PA-28-235 · Castaic, CAThe pilot requested and received a weather briefing for the cross country flight. VFR flight was not recommended due to multiple cloud layers and mountain obscurement. The wreckage was located the following morning at the 3,500 foot elevation in mountainous…NTSB LAX85FA213Accident · 1 fatalField investigationFinal reportBeech F33A · Goleta, CAWhen the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…NTSB DEN85LA122Accident · Minor injuriesLimited investigationFinal reportBeech BE36 TC · Silver City, NMThe acft was substantially damaged during a wx encounter near Silver City, NM. Icing and turbulence in IFR conditions prevailed at the time. The plt initiated a climb from 15,000 ft to 17,000 ft because of rime ice conditions. The autopilot was used during…NTSB CHI85LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · St. Paul, MNShortly after takeoff, while climbing thru aprx 700 ft AGL, the eng developed a severe vibration & a loud 'clanking' sound. These were followed by a partial loss of power. During a subsequent forced landing, the acft's right wing hit a tree & the nose gear…NTSB CHI85FA170Accident · No injuriesField investigationFinal reportBeech E18S · Janesville, WIOn April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the…NTSB ATL85LA205Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Union City, TNPilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…NTSB ATL85LA144Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Germantown, KYDuring cruise flt over hilly terrain, the plt noted a power loss that he described as the eng 'dying back and then catching again.' He was unable to maintain alt & selected a field for a landing. During the apch, the left main gear & prop hit 2 power lines.…NTSB ANC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Wasilla, AKThe primary cause of this accident was the airplane striking the soft spot on the runway. Underlying factors were the pilot in command's inability to distinguish the soft runway surface from surrounding runway surfaces, and the unusually warm temperatures for…NTSB SEA85LA093Accident · No injuriesLimited investigationFinal reportLake Buccaneer · Dexter, ORThe acft bounced during touchdown several times while attending to land on the water. The acft was too close to a dam to make a go-around. The acft then struck the dam head on.NTSB NYC85FGM03Accident · Minor injuriesFinal reportIstvanick Zipppy Sport · Connellsville, PAThe acft contacted trees following a loss of pwr shortly after takeoff. Plt stated he performed 3 high speed taxi runs during which the acft and eng operated normally. Witnesses stated the acft became airborne on the 4th taxi run, climbed to aprx 75 ft AGL…NTSB NYC85FA109Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · No. Hampton, NHOn April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…NTSB MKC85FA087Accident · 1 fatalField investigationFinal reportGrumman G-164A · Coy, ARWhile approaching a field to dispense rice, the acft struck a set of power lines. The plt had flown over the same set of power lines for nearly 2 hours. The flagmen stated they heard the acft strike the wires and one of the wires made a 'pop' as if being…NTSB MIA85IA152Incident · No injuriesIncident investigationFinal reportCessna 402C · West Palm Beach, FLThe nose gear collapsed on touchdown. An exam of the nose gear actuating rod, the only positive down lock, revealed that it had been improperly adjusted.NTSB MIA85FA153Accident · 3 fatalField investigationFinal reportSikorsky S-58ET · Gulf Of MexicoThe helicopter disappeared while on an overwater flt from key west, FL to ft peirce, FL. One occupant & the wreckage of the helicopter were subsequently recovered from the Gulf Of Mexico. The plt & the other occupant were not located & were presumed dead.…NTSB LAX85LA219Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Prescott, AZThe acft departed rwy 21. The reported surface winds were 190 degs at 12 KTS gusting to 29 KTS. The acft was climbing at 200 fpm until reaching 800 ft AGL. The plt reported that he considered the climb rate as being too slow and elected to negotiate a…NTSB LAX85FA217Accident · Minor injuriesField investigationFinal reportBell 206-L1 · Kailua/Kona, HIA revenue sight-seeing helicopter flight operating under 14 CFR 91 collided with lava rock while attempting a forced landing on the summit of muana loa volcano after a partial loss of power. The pilot stated that while in a shallow downwind turn at aprx 200…NTSB FTW85LA195Accident · Serious injuriesLimited investigationFinal reportCessna T-210-NII · Denton, TXThe acft was damaged during a forced landing in a construction site following a loss of pwr due to fuel exhaustion. The plt stated sufficient fuel was on board for the x-country from flagstaff, AZ, to plano, TX. Upon reaching the plano area the plt could not…NTSB FTW85LA189Accident · No injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the…NTSB DEN85LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Opheim, MTThe plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged.NTSB CHI85MA169Accident · 7 fatalMajor investigationFinal reportCessna 310R · St James, MIDuring a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…