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 FTW84FA086Accident · 1 fatalField investigationFinal reportBeech D18S · Brownsville, TXThe plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…NTSB CHI84FA053Accident · 3 fatalField investigationFinal reportCessna T210M · White Lk Twnshp, MIAt about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the…NTSB ATL84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Charlotte, NCDuring a wx briefing, before takeoff, the plt was advised that the winds at Charlotte, NC were forcast to be from 230 at 13 gusting to 24 KTS. He was also advised to expect moderate to severe turbulence as well as high en route winds. While en route, he…NTSB ATL84FIA02Accident · No injuriesFinal reportPiper PA-28R-180 · Manassas, VAThe plt reported that during a night landing, the right main gear failed & the acft went off the right side of the rwy. An FAA investigator reported that the acft had touched down hard during the landing.NTSB MKC84FA033Accident · 1 fatalField investigationFinal reportBeech TC-45J · Kansas City, KSThe acft was a Beech TC-45J that had been modified into a hamilton turboliner under STC SA-1821-WE. During arrival, the plt reported that he encountered moderate icing at 4000 ft. he made a localizer-only apch to rwy 35. An ATC specialist stated that they saw…NTSB FTW84LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXDuring a touch-&-go landing, the acft bounced back in teh air after touching down. At that time, the sudent plt reacted by pushing forward on the control yoke. The acft then impacted, nose down, & the nose gear collapsed.NTSB DEN84LA040Accident · No injuriesLimited investigationFinal reportCessna P206C · Tremonton, UTBefore takeoff, the plt obtained a wx briefing & filed a flt plan, but did not ask for NOTAMS. He was unaware that the destination arpt was notamed as closed until after the flt. He said that during arrival, he 'discovered an unplowed but apparently used…NTSB NYC84LA045Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Somersworth, NHThe acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and…NTSB MIA84FA040Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Lakeland, FLThe acft was on its first production flt test. Shortly after lift-off it was observed to enter an abrupt right bank, followed by a steep left bank before crashing. Examination of the left wing revealed that its aileron cables were connected to their…NTSB FTW84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Bulverde, TXThe acft collided with a ditch during landing rollout after loss of control and a groundloop. According to the plt the landing was normal on a 2850 ft strip. The acft groundlooped at slow speed and went into a ditch off the right side of rwy 16. This flt was…NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB CHI84FA054Accident · 1 fatalField investigationFinal reportBeech 77 · Sidney, OHThe aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported…NTSB ATL84FA061Accident · Serious injuriesField investigationFinal reportCessna 210A · Columbia, SCThe acft collided with a wall during a downwind forced landing. The engine had quit at 200 ft after takeoff. The plt turned right with the gear up. He landed on a football field and bounced down a track field into a fence and wall. When the engine was…NTSB MKC84LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · David City, NEThe instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.…NTSB MIA84FA039Accident · Serious injuriesField investigationFinal reportPaul S. Kerr Condor III 400 · Boca Raton, FLThe instructor plt (CFI) & student were practicing apchs in a 2-place/registered ultralight with single controls. Just prior to touchdown, the CFI told the student to go around. After initiating a climb, the acft encountered turbulence. The student…NTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…NTSB LAX84LA091Accident · No injuriesLimited investigationFinal reportLet L-13 · Jacumba, CAThe acft collided with a bush and groundlooped short of the rwy. The wind was unusually strong and the glider plt stated he misjudged its effect and should have flown the base leg closer. The acft landed short of the rwy and ground looped.NTSB LAX84FU023Accident · Serious injuriesFinal reportMotorized Gliders Tierra · Bullhead City, AZAccording to the plt, he had no previous flt time in ultralight acft. Before taking off, he taxied the ultralight several times to get the feel of the vehicle. During departure, the plt took off from a taxi strip west of rwy 17. The strip was used by…NTSB FTW84LA087Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched…NTSB FTW84FA083Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Hebbronville, TXThe flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised…NTSB FTW84FA082Accident · 1 fatalField investigationFinal reportCessna 310K · Hodgen, OKThe plt had purchased the acft at rexburg, id on the day of the accident. Reportedly, the previous owner had flown with the plt, before the plt departed rexburg, and said he had flown the acft very well. The previous owner stated that the DME was not…NTSB DEN84LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Englewood, COThe acft collided with a snowbank and nosed over during landing. The plt said the acft was rolling out when it hit some slush on the rwy and was pulled into a snowbank on the left. The nose gear folded when it hit the 3 ft snowbank and the acft nosed over.…NTSB DEN84FA038Accident · Serious injuriesField investigationFinal reportBell 206B · Ft. Morgan, COThe helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…NTSB ATL84FA059Accident · 3 fatalField investigationFinal reportBeech A36 · Gulfport, MSPrior to the approach the plt was advised that the wx was sky obscured & visibility 1/4 mi in fog. The plt acknowledged 'roger we'll come on in and give it a shot.' The acft collided with trees about 500 ft short of the middle marker. It was reported that the…NTSB SEA84LA025Accident · No injuriesLimited investigationFinal reportBell 206-BIII · Kooskia, IDThe helicopter landed hard and rolled over to the right. The events started when the pilot heard the end of a seat belt banging against the outside of the acft where it had been caught in the door. The pilot decided to land and secure the belt. During landing…NTSB NYC84FA046Accident · 1 fatalField investigationFinal reportCessna 172H · Hershey, PAPrior to takeoff the plt was advised that 'a storm was moving in.' The plt replied he knew that & was only going up for a short flt. Shortly after takeoff snow began to fall, & the acft was observed flying perpendicular to the rwy below traffic pattern…NTSB MIA84FA038Accident · 1 fatalField investigationFinal reportCessna 172RG · Cross City, FLWhile in the vicinity of Cross City the plt requested VFR flt following from jacksonville ARTCC. While he was in radio &radar contact, the controller suddenly lost radar contact with the flt. Radar indicated that the acft made a rapid descent from the cruise…NTSB LAX84LA090Accident · No injuriesLimited investigationFinal reportSkov-Papworth Quickie 2 · Palo Alto, CAThe plt reported that during the landing, the acft stalled while it was over the theshold of the rwy at about 4 to 5 ft AGL. Subsequently, it landed hard damaging the right canard & right main gear. The acft then skidded off the rwy & came to rest.NTSB LAX84LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thermal, CAAfter the student returned from a solo x-country, she encountered a x-wind condition during her landing. She reported that on final apch for the landing, she selected full flaps. Power was reduced to idle before touchdown. During the landing, the acft…NTSB LAX84LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fairfield, CAAfter taking off & while climbing thru about 100 to 300 ft, the eng lost power. During a forced landing, the acft impacted a fence & a berm, and went over railroad tracks, then came to rest inverted in a ditch. An exam of the acft revealed corrosion in the…NTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…NTSB DEN84LA036Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Cokeville, WYThe plt reported that snow had been falling regularily for the previous few days before the flt. He departed the staging area with 12 drill crew members. At that time, the visibility was 2 to 3 mi & a ceiling of 800 to 1000 ft. the plt flew 9 of the…NTSB DEN84LA034Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Helena, MTThe acft propeller struck a passenger who was attemping to sweep snow off the acft. The plt's and passenger's version of mishap vary. The plt stated he instructed the passenger to stay away from the acft. The passenger stated the plt toldhim to sweep the snow…NTSB LAX84LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Truckee, CAThe acft collided with trees and the terrain while trying to fly through donner pass on a solo x-country. There was an overcast sky and the mountains were 8300 to 9100 ft high. The plt was quoted as stating that the acft did not climb as well as he…NTSB LAX84LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAThe plt reported that he forgot to remove the aileron blocks before the flight. When he was taking off, the acft began to roll to the left. He was unable to control the bank attitude with rudder control, so he 'cut' the power. Seconds later the acft crash…NTSB DEN84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Herreid, SDThe acft ran into a creek bed during an off arpt landing and the landing gear collapsed. The plt was conducting an aerial hunt of coyotes. After shooting one he sought a place to land to pick up the carcass and stated that although he inspected the area from…NTSB DEN84LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Colorado Spring, COThe plt reported that during his apch to land, the glider encountered turbulence. He stated that he was 'unable to maintain directional control on landing contact with ground.' The glider touched down in a left yaw. Shortly after touchdown, he regained…NTSB ATL84LA060Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, KYEarlier in the day, an annual inspection had been completed. There were no refueling facilities on the arpt, so the plt/mechanic drove to another location & purchased a can of gasoline (6 gals) which he added to the tanks. He then started the eng &…NTSB ANC84LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe acft was taking off from an unimproved area covered by 2 inches of snow. At about 80 ft into the takeoff roll the acft bounced left into muskeg, collapsing the landing gear.NTSB LAX84LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAAt about 75 ft AGL in a procedure turnaround the acft stalled & collided with orange trees.NTSB DEN84LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rawlins, WYThe plt stated that the approach into Rawlins was normal but while on short final he realized that the acft was too low. The acft was actually lower then the runway which is located on a plateau. He attempted to correct but lost airspeed and landed short. The…NTSB ATL84FU002Accident · 1 fatalFinal reportAmerican Aerolights Double Eagle · Cape Carteret, NCReportedly, the plt had previously flown in a 2 place ultralight vehicle, but had not flown in one that was equipped with a canard. He indicated to the owner that he would like to taxi the ultralight. The owner obliged after explaining the operation of the…NTSB NYC84FA042Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Bennington, VTThe acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is…NTSB LAX84LA081Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot stated that the acft veered to the right during landing. The pilot tried left brake with no success. The acft groundlooped and the left gear failed. The brakes were examined after the accident but due to the damage to the lines & and fittings no…NTSB DEN84FA031Accident · 1 fatalField investigationFinal reportChampion 7GC · Douglas, WYThe plt took off on an aerial observation flt to spot cattle in a mountainous area. When he failed to return, a search was initiated. The plane was found in a valley between 2 mountain ranges. An investigation revealed that the acft had crashed while in a…NTSB ATL84FA057Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Atlanta, GAAfter gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the…NTSB MKC84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAAfter takeoff for an FAA part 135 check ride, the aircrew were unable to get a positive up indication for the landing gear. The gear was recycled & then the left main gear would not get a down & locked indication. Repeated attempts to extend the left main…NTSB MIA84IA037Incident · No injuriesIncident investigationFinal reportCessna 182-RG · Jacksonville, FLOn landing touchdown the nosegear collapsed and the acft slid to a stop. One of the nose gear lock pins was found failed.NTSB MIA84FA036Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Kathleen, FLThe acft impacted in a swampy area in a fast dive which separated about 6 ft of the left wing. The acft was being vectored on radar when it suddenly began to steer erratically and go off the radar scope. The plt had radioed that he 'must have gone over some…