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 ANC84FA063Accident · No injuriesField investigationFinal reportMaule M-6-235 · Anchorage, AKThe acft bounced and the plt gave it full throttle to recover. The acft nose came up, the left wing dropped, and the acft veered off the rwy into two tied down acft. The acft had just had large tires put on to replace wheel skis. The plthad made only 4 wheel…NTSB SEA84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Gerlach, NVThe acft went off the 1500 ft rwy during a x-wind landing and nosed over. The plt said a gust of wind 'blew the plane too FAR down the runway, applied power, lost altitude, landed off the runway and the plane flipped upside down.'NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.NTSB NYC84LA166Accident · No injuriesLimited investigationFinal reportCessna C188 · Seneca Falls, NYPilot attempted to compensate for gusty wnd cond by lnding the acft tail high. The acft began to wx vane and in an effort to correct, the plt used excessive rt brake. The braking action combined with the gusty wnd exceeded the elevator authority and the acft…NTSB MIA84LA167Accident · No injuriesLimited investigationFinal reportCessna 172N · Ft.Lauderdale, FLThe acft nosed over during takeoff after running off the left side of the rwy. The wind was reported from 50 degrees at 13 KTS gusting to 23 KTS prior to the accident. After the accident the wind was from 030 degrees at 14 KTS.NTSB MIA84FA166Accident · 1 fatalField investigationFinal reportBell UH-1B · Clermont, FLThe plt was not aware that two ground attendants were riding the cable during a logging operation when there was an accidental cable release & the attendants fell to the ground. Examination of the acfts hook did not reveal a system failure or malfunction.…NTSB MIA84FA164Accident · 1 fatalField investigationFinal reportMooney M-18C · Sugar Loaf Key, FLThe acft was observed making several passes over a friends house. At the end of the third pass during, a climbing left turn, the right wing separated from the acft. Inspection of the wreckage revealed wood rot in the main wing spar. The last known inspection…NTSB LAX84LA294Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E (Soloy) · Delano, CAThe helicopter experienced an inflt failure of an eng mount, pn 63181-5, which bent the collective control rod & forced the the collective pitch into the up position. The helicopter then settled into the grapes it was spraying & made a hard landing. An…NTSB LAX84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Hawthorne, CADuring the first ground supervised solo flight, the tower controller noticed a tone change in the student pilot's voice while on down wind leg of the traffic pattern. On base leg the student did not extend the second increment of flaps as routinely…NTSB FTW84LAMS4Accident · 1 fatalFinal reportPiper PA-32-260 · Lafayette, LAThe acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…NTSB FTW84LA228Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bay City, TXWhile spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed…NTSB DEN84LA146Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Winner, SDThe plt reported that a gust of wind was encountered during the landing roll. The acft swerved to the right & left rudder did not correct the situation. The acft left the rwy & collided with a ditch. The plt said that he examined the tailwheel after the…NTSB DEN84LA145Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Canon City, COThe acft went off the side of the rwy into a ditch during landing. The plt said he was only using 20 degrees of flaps due to the wind and after touching down the acft was blown off the rwy. While in the dirt the plt added power 'to try and get lift to either…NTSB ANC84LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gakona, AKThe acft broke the ice on fox lake during landing and nosed over. The plt refused to file an accident report and is not reachable by telephone. No flt plan was filed so departure point is unknown as are the details of the occurrence.NTSB ANC84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe plt lost directional during landing roll with two pax in the rear seats. He stated that the right brake failed after touchdown.NTSB MKC84LA135Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Pleasant Hill, MOThe acft nosed over during a forced landing after the engine failed. Investigation revealed an exhaust valve had failed and imbedded itself in a spark plug hole. It was determined that this was a fatigue failure.NTSB LAX84LA285Accident · No injuriesLimited investigationFinal reportNavion A · Rio Linda, CAThe pilot reported a gradual loss of power leading to complete engine failure. A forced landing was accomplished in a city street, with damage to the wing at collision with a street sign. Although the aircraft was serviced with automotive gasoline, the engine…NTSB FTW84FU006Accident · 2 fatalFinal reportMitchell T-10R263 · Horizon City, TXThe ultralight departed west Texas arpt at about 1700 MDT for a local instructional flt with 2 persons on board. It was last seen flying at about 1800 MDT a short distance west of the arpt. When it did not return at 2100 MDT, the arpt manager notified the…NTSB ATL84LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Rosedale, MSThe plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over.NTSB ATL84LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Buckingham, VAThe acft bounced and drifted during the landing flare. The plt added power to go-around and was unable to clear the trees near the rwy.NTSB ANC84LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe student plt was observed to land nose wheel first, bounce to a considerable altitude, nose over and contact the runway on the nose wheel.NTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…NTSB NYC84FA165Accident · Serious injuriesField investigationFinal reportBeech B19 · College Park, MDThe flt had arrived at the arpt between 1600 & 1615, & had landed on rwy 15. Winds generally were out of the sw at ABOUT10 KTS. The plt stated that during the flt he had observed a thunderstorm west of andrews afb (10 mi south.) After loading an ATC simulator…NTSB NYC84FA163Accident · 2 fatalField investigationFinal reportCessna 310K · New Cumberland, PAThe plt departed VFR without a formal wx briefing or filing a flt plan. The wx at dest was VFR when the plt departed. The forecast indicated that ceilings would lower. The wx did, in fact, deteriorate while the flt was enroute and the plt obtained an IFR…NTSB MKC84LA134Accident · No injuriesLimited investigationFinal reportBeech BE23 · Richmond, KSWhile in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident…NTSB MIA84FA163Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Opa Locka, FLThe plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel…NTSB FTW84LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Haskell, TXPlt lost directional control of the acft during the landing roll and acft veered off the rwy striking a dirt bank. The nose gear collapsed upon impact with the bank. The plt reported only 145 hours of flt time in the 18 years she has had had her private…NTSB CHI84FA179Accident · 2 fatalField investigationFinal reportMooney M20J · Highland Hgts, OHTwo mins after takeoff, acft impacted terrain left wing down, measured 63 degrees nose down, well left of designated departure course. Investigation revealed no malfunction or failure in the acft structure, power plant or systems. Plt's actual instrument…NTSB ATL84LA165Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Smithfield, NCThe plt had only 1 hr of night experience & was practicing night landings to maintain currency. During a landing, the acft bounced & the plt added power to recover. As power was applied, the acft went off the left side of the rwy & subsequently collided with…NTSB ANC84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ester, AKThe plt maded an off-arpt landing on a frozen river with an 'overflow.' During the rollout, the acft hit a 12 inch deep pocket of slush & nosed over.NTSB SEA84LA112Accident · No injuriesLimited investigationFinal reportCessna 188B · Shedd, ORWhile landing on a 1600 ft ag strip, the plt realized he had too much speed. However, there were power lines at the departure end of the strip, so he elected not to attempt a go-around. He intentionally ground looped the acft to avoid a ditch & road at the…NTSB NYC84LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Stonington, CTWhile on a x-country flt, the student plt became lost & his fuel supply became low. He had difficulty contacting a ground station, but finally did so after receiving assistance from other plts. He was requested to squawk 7700 on his transponder, but the…NTSB NYC84IA164Incident · Minor injuriesIncident investigationFinal reportBarnes Firefly 7 · Gorham, MEDuring touch and go landings the balloon encountered increased winds. The balloon touched down hard tilting the basket onto its side. A passengers arm became caught between the basket and the ground.NTSB MIA84FA162Accident · No injuriesField investigationFinal reportPiper PA-31-325 · Eglin Afb, FLAfter arriving at Eglin Afb, the plt determined he would need more fuel to complete the next leg of the flt. However, there was no avgas refueling available at Eglin. The plt disembarked the pax & flew IFR to ft walton beach to refuel. A missed approach was…NTSB LAX84FA283Accident · No injuriesField investigationFinal reportPiper PA-22 · West Covina, CAWhile returning to the arpt & towing a banner, smoke entered the cockpit & a small fire began buring, forward of the left/lower part of the firewall. The plt turned the acft to land in a field. He opened the right cabing door, all air vents & the window on…NTSB FTW84LA225Accident · No injuriesLimited investigationFinal reportGrumman G164A · Fenton, LAThe acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…NTSB CHI84FA180Accident · 1 fatalField investigationFinal reportColonial C-2 · Stone Lake, WIThe plt had flown to little sissabagama lake where he owned a cabin. A witness had observed the last 3 mins of flt but not the actual impact with the water. The acft was later found inverted in 15 ft of water 300 ft from a shore. Plt was found 150 ft from the…NTSB ATL84LA167Accident · No injuriesLimited investigationFinal reportCessna 188B · Paxville, SCThe acft nosed over short of the rwy after the engine failed to respond to the plts attempt to add power to reach the rwy. It was found after the accident that the carb heat control door brackets were worn which allowed the butterfly valve door to separate…NTSB ATL84FA164Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Painter, VAAfter encountering low ceilings, the plt attempted a precautionary ldg. Upon realizing lights from the ground were on a house, a go-around was initiated with a climbing left turn. The acft then flew into trees one fourth to one half mile from the house.NTSB NYC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Muskeget Island, MAThe acft was unable to clear trees during the initial takeoff climb. The plt raised the nose of the acft and the acft stalled contacted the trees.NTSB NYC84LA160Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Newburyport, MAWhile landing on rwy 28, the acft encountered a gust of wind. The plt reported that the wind caught the tail of the acft & caused it to drift. He stated that he continued the landing, but applied the brakes too fast & the acft nosed over. He reported the wind…NTSB NYC84FA159Accident · No injuriesField investigationFinal reportPiper PA-28-140 · North Andover, MAThe plt stated to police that he was positioning the prop for a photo when the engine started and the airplane traveled 2500 ft unattended across the arpt before it became airborne and struck the rear of a commercial bldg that housed three businesses,…NTSB NYC84FA158Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Shirley, NYWhile climbing with a glider in tow, the tow acft pitched nose up. The glider & tow plts released the tow rope & the glider plt landed safely. The tow acft maintained a nose high attitude, stalled, then entered an uncontrolled descent & crashed. An…NTSB MKC84FA281Accident · 1 fatalField investigationFinal reportMooney M20C · New Blaine, ARDespite a wx briefing forecasting IMC and discouraging VFR flight, the non-instrument rated plt departed aprx 1 hour before the accident. Impact occurred in wooded rising terrain at an elevation of about 1,957 ft MSL at an aprx nose down attitude of 4 degs.…NTSB LAX84LA284Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Hayward, CAThis acft landed in trail behind a lead acft (N53BT) and bounced on landing. During his recovery procedures he overtook and collided with the lead acft.NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB CHI84LA181Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ridge Farm, ILThe helicopter rolled over after a hard landing following loss of rotor RPM. The plt reported that during initial climb at about 300 ft AGL the rotor decreased about 500 RPM. He tried to regain rotor RPM until about 100 ft AGL and then tried an autorotation.…NTSB CHI84LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Porte, INThe pilot stated that he initiated the landing flare 'too late,' and the acft landed hard. There was subst damage to theto the landing gear and left wing.NTSB CHI84LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot landed with excess airspeed & bounced. The second landing was harder than the first & collapsed the nose wheel. The acft nose over as it slid off the right side of the rwy. Investigation revealed that the tower had advised the plt to hold…NTSB ATL84FA168Accident · 2 fatalField investigationFinal reportCessna 172RG · Dallas, GAApproximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…