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 CHI85LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Red Lake Falls, MNThe acft contacted wires during an aerial application flt. The plt stated he was maintaining extra alt to avoid tall weeds and the clearance below the wires was misjudged. The wires severed the vertical fin and rudder.NTSB ANC85LA148Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague Island, AKThe plt stated that during the takeoff roll, the acft was kept close to the waterline to stay on the hard sand. After rolling aprx 700 ft, the tail wheel was raised. At about that time, the left gear sank in soft sand & pulled the acft to the left.…NTSB ANC85LA147Accident · No injuriesLimited investigationFinal reportCessna 172 · Chickaloon Flat, AKThe plt made an off-arpt landing on an area of clay silt with sparse grass. After slowing the acft to about 20 to 25 mph, the nosewheel went into a shallow gully of soft clay. The acft then stopped abruptly & nosed over.NTSB NYC85LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Wildwood, NJN21521 taxied onto runway 10 at the intersection of runway 14 after observing another aircraft taxi and take off from that point. N21521 did not attain sufficient airspeed for takeoff prior to running out of available runway. The pilot did not apply hard…NTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…NTSB FTW85LA328Accident · No injuriesLimited investigationFinal reportPiper J4A · Duncan, OKThe plt was practicing short fld landings when the accident occurred. He stated the acft ballooned and he advanced the throttle but the eng failed to respond immediately. The acft stalled at 2 ft above the ground according to the plt. Hardcontact with the…NTSB FTW85LA305Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sand Springs, OKThe plt allowed the acft to get too low on the VFR final apch. He added pwr and stated a gust of wind tipped the acft tothe left. When he corrected for this the acft's nose dropped and the nose sheel contacted the ground and separated. The acft then nosed…NTSB DEN85LA209Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Superior, MTThe plt was flying with his wife on a pleasure flight to Idaho when smoke started coming into the cabin. Engine oil pressure went to zero. The plt secured the engine and made a forced landing to a farmer's field. The acft was substantially damaged; however,…NTSB CHI85FA334Accident · 1 fatalField investigationFinal reportCessna 182Q · Walworth, WIThe pilot took off with weather conditions of 100 ft ceiling & visibility of 1/4 mile. Theflight tookd off to the south & crashed in a corn field south of the airstrip tracking 058. The engine was heard at a high power setting just prior to impact.NTSB ATL85LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Wilmington, NCDuring landing roll the plt lost directional control of the acft & ran off the side of the rwy. The acft nosed down in soft soil resulting in substantial damage. The plt reported a gust of wind was encountered which resulted in the control loss.NTSB ATL85LA236Accident · No injuriesLimited investigationFinal reportCessna A188B · Trenton, ALThe pilot stated that the eng lost power while he was maneuvering for another spray run over the field. The aircraft settled into the trees and a post-crash fire developed.NTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…NTSB ANC85LA145Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Eureka, AKPlt approach strip high and fast, struck a dirt berm and turned over.NTSB ANC85FA146Accident · 2 fatalField investigationFinal reportPiper PA-30 · Kodiak, AKDuring a wx briefing at 0719 adt, the plt was advised that VFR flt was not recommended. Later, at 0827. He called the fss to update his wx & filed an IFR clearance. At 0938, the acft departed anchorage. During arrival at Kodiak, the acft was cleared for an…NTSB SEA85LYA01Accident · No injuriesFinal reportRockwell S2R · Caldwell, IDAn aero commander S2R had been modified by the installation of an air research TPE-331-43A power plant. During an aerial application flight the pilot heard a loud bang and experienced a loss of power. Investigation revealed the first stage turbine whee, part…NTSB MIA85LA226Accident · No injuriesLimited investigationFinal reportCessna 210N · Melbourne, FLAct swerved left after landing and crashed at drainage ditc h appx 50 ft north of rwy. The pilot stated he was unable to effect a timely recovery from the left swerve and that 'a more consistent training effort could sharpen my reactions to this sort of…NTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…NTSB LAX85LA338Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAOn aug 4, 1985 an Aeronca 7AC collided with the ground while buzzing over a sand bar near Santa Paula, CA. VMC existed at the time. The ac sustained substantial damage and the pvt plt received minor injuries. He reported no mechanical problems with the ac…NTSB CHI85LA335Accident · No injuriesLimited investigationFinal reportBeech A23A · Griffith, INThe preflight and takeoff were uneventful. Shortly after takeoff the plt experienced a partial pwr loss and discovered that he could not maintain level flt. He then performed a forced landing in a fld. Following the accident an FAA airworthiness inspector…NTSB ATL85LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Leesburg, GAThe aircraft suffered a loss of power due to water in fuel and made an emergency landing in a field. During landing roll the aircraft collided with trees at the end of the field.NTSB ATL85FA234Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F · Chamblee, GAReportedly, the plt & passengers had gone to a local establishment, where the entire party had consumed an unspecified amount of alcoholic beverages. One passenger reported that after arriving at the arpt, the plt made a walk-around inspection of the…NTSB ANC85LA158Accident · No injuriesLimited investigationFinal reportCessna C-172M · Wasilla, AKThe pilot-in-command was on a personal flight with the purpose of observing a hunting camp from the air. While maneuvering in the canyon, the pilot stated he encountered a downdraft. He applied full power and lowered the flaps 20 degrees. The airplane…NTSB ANC85LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Mccarthy, AKThe plt stated that while executing a 180 deg right turn the acft drifted 50 ft to the east of rwy 19 where it struck a row of trees. The acft continued in a steep descending turn. The acft stalled and crashed into a wooded area.NTSB NYC85LA198Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Quakertown, PAThe acft collided with wires during a lndg attempt. The acft was thrown out of control and dragged a wing after which it nosed over. The plt said that he thought the wires had been cleared. He was trying to put the acft right at the edge of the field because…NTSB MKC85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Cape Girardeau, MOWhile on a solo x-country flt, the student plt became lost/disoriended. When the acft's fuel level became low at dusk, the student elected to land on a gravel road. As the acft was on the landing roll-out, the left wing struck a brace wire for a power line…NTSB LAX85LA342Accident · No injuriesLimited investigationFinal reportPitts S-2A · Van Nuys, CAAfter practicing acrobatics the plt returned to the arpt for the purpose of practicing landings. He made the first one successfully, but flared out high on the second landing. The acft bounced 'hard' on the rwy twice, & the plt elected to go around. After…NTSB FTW85LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Katy, TXThe plt stated he had his destination arpt in sight and then lost sight of it. While attempting to locate the arpt the eng lost pwr. He attempted a emergency landing on an interstate hwy 10 west of houston, TX. After touchdown and during rollout the right…NTSB FTW85LA304Accident · No injuriesLimited investigationFinal reportCessna 172 M · Arcadia, LAThe plt stated he heard a 'boom' and experienced a partial power loss when he was about 10 ft above the rwy during the initial takeoff climb. He was about half way down the 3000 foot rwy at this time. He aborted the takeoff and landed. However, he was not…NTSB FTW85LA294Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Port Isabel, TXThe acft was substantially damaged when it undershot the runway and cartwheeled during an emergency landing following an engine failure in the traffic pattern. The plt reported that initial examination of the engine revealed that initial examination of the…NTSB CHI85LA332Accident · Minor injuriesLimited investigationFinal reportMcfarland Quickie 2 · Port Clinton, OHThe pilot failed to release the parking brakes before landing after setting the brakes while enroute. The acft swerved off the runway and nosed over.NTSB CHI85LA331Accident · No injuriesLimited investigationFinal reportCessna 150K · Romeo, MIThe acft nosed over after contacting a ditch during a landing roll. The student plt, on his second solo flt, was practicing touch & go landings when the accident occurred. He stated he rushed on final apch because other acft were lined up waiting to takeoff.…NTSB CHI85LA330Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lansing, ILOne of the pilot's eyes became irritated. He attempted to scratch it on short final. A hard landing resulted. The aircraft became airborne & the pilot added power. His glasses became dislodged. At this time the pilot was attempting to regain control as the…NTSB CHI85FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172The aircraft was seen to depart racine, WI on August 3, for ft meyers, FL, but never arrived at its destination. On the fourth day of the search a ramp check at albany-dougherty county airport, Georgia indicated that the aircraft was refueled there at approx…NTSB ATL85LA238Accident · No injuriesLimited investigationFinal reportEipper MX-2 · Greenville, SCWhile climbing altitude the parachute , which was secured to the right seat, was inadvertently deployed and became tangled in the propeller. The acft descended to the ground while inverted at a slow rate.NTSB ATL85LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Burnsdie, KYThe acft bounced during touchdown on a grass airstrip and veered off the left side of the rwy. Before proper alignment was gained the left wing struck a parked acft and both acft incurred substantial damage.NTSB ATL85LA232Accident · No injuriesLimited investigationFinal reportCessna 150L · Hattiesburg, MSDuring a full-flap approach to landing, the pilot saw that the acft was going to land long and he initiated a go-around. He began retracting the flaps at the same time, and the acft started to settle. The pilot then elected to continue the landing straight…NTSB ATL85LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Hilton Head Is., SCThe commercial/cfi plt and a passenger were flying just off shore at about 700 ft when the engine quit. He could not clear trees along the shore and the beach was unusable due to fallen trees. The plt landed in the ocean and both occupants swam to shore. The…NTSB ATL85FA230Accident · No injuriesField investigationFinal reportCessna 210N · Chamblee, GAPlt had obtained check out in acft prior to departure on x-cflt. About 3.35 hrs into flt called atl ctr exp concern about fuel. At that time acft was about 4 mi w of rome ga VOR and about 15 mi from rome apt. Plt nor center were sure if fuel was avail at rome…NTSB NYC85FNE02Accident · No injuriesFinal reportEarl F. Folsom Sonerai II · Waterbury, CTThe homebuilt sonerai ii made an off airport landing 3 minutes after takeoff. The aircraft received substantial damage and the sole occupant was uninjured. Post crash examination of the aircraft showed the fuel tank was empty. However, there was fuel in the…NTSB NYC85FGM05Accident · 2 fatalFinal reportJames Postlewait RV-4 · Zelienople, PAA witness reported that when the acft was departing, the takeoff run & beginning of the climb appeared to be normal. However, at about 300 to 400 ft AGL, the left wing dropped & the acft pivoted to the left, then the plane crashed in a steep nose down…NTSB LAX85LA337Accident · No injuriesLimited investigationFinal reportCessna 172 M · Island Mountain, CAUpon arriving over the uncharted, 2000-foot-long dirt airstrip, the plt placed the acft into landing configuration & attempted to land. The acft touched down hard, bounced 3 times, 'floated,' overran the runway's end, went into a ditch & nosed over. The plt…NTSB DEN85LTG05Accident · No injuriesFinal reportGrumman G164A · Colfax, NDThe plt noticed the spray pump was stuck in the off position shortly after takeoff for the aerial application flt. The decision was made to land on a private strip and during landing on the soft fld, the acft contacted high vegetation and nosed down.NTSB DCA85AA031Accident · 135 fatalFinal reportLockheed L-1011-385-1 · Dallas/Ft Worth, TXThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Psbl…NTSB ATL85LA229Accident · No injuriesLimited investigationFinal reportCessna 150K · Orchard Hill, GAThe acft suffered a loss of pwr due to fuel exhaustion and the plt made an emergency landing in a fld. During landing roll the acft collided with trees at the end of the fld. Post accident exam of the acft revealed one gallon of fuel in the right fuel tank…NTSB ANC85LA144Accident · No injuriesLimited investigationFinal reportCessna C-182K · Port Alsworth, AKThe pilot-in-command stated that he misjudged his height above the runway's surface after making his approach from over the water. He flared 10 to 15 foot above the ground. Upon touchdown he lost control of the airplane and it left the runway's surface and…NTSB ANC85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe plt stated on short final apch he noticed a x-wind stronger then expected. After touchdown directional control of the acft was lost. The acft then exited the rwy into a open ditch. At the time of the accident the wind was 280 degs at 12 KTS.NTSB NYC85LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Stormville, NYAccording to the pilot, during the second touch and go landing, at abut 30 feet from touchdown, a wind gust lifted and veered the aircraft left of the runway centerline. The pilot attempted to go around applied full power; however, the left wing collided with…NTSB MIA85LA224Accident · No injuriesLimited investigationFinal reportBell TH-13T · Quitman, GAPilot stated that after completing a left turn at the end of a cotton field, the aircraft yawed sharply to the left and the yaw could not be controlled with cyclic control. Another left turn at the oppsite end of the field the aircraft again yawed to the…NTSB MIA85LA223Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Ochopee, FLThe plt stated that he dropped his passenger off at a water station in the everglades, water taxied away from the station, accellerated up to 3100 RPM & just before he added collective pitch the transmission ass'y departed the helicopter, it rolled to the…NTSB LAX85LA336Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Arroyo Grande, CAWhile hovering and slinging an external load over rough terrain the eng chip light illuminated. The plt immediately positioned the acft to release the load and the eng began making a 'whining' noise. Several seconds later all eng power was lost. The plt…