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 FTW85LA322Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cushing, OKThe plt was test flying the acft after a major eng overhaul.a left turn was made away from the arpt after takeoff and immediately thereafter the eng lost pwr. With no suitable landing area within gliding distance, the acft was manuevered straight ahead where…NTSB DEN85LA220Accident · No injuriesLimited investigationFinal reportBeech 76 · Sula, MTPlt stated that he overflew airstrip to 'make sure it was clear.' During the landing roll, he saw shrubbery on the rwy and attempted evasive action. The acft veered left and the left main gear rolled into a drainage ditch and the left wing contacted a fence…NTSB DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…NTSB ATL85LA260Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Prestonburg, KYThe pilot stated that while on short final the aircraft encountered a down draft which caused a sudden loss of altitude resulting in a hard landing. The aircraft tire blew on landing and the aircraft veered off of the side of the runway and was substantially…NTSB ATL85LA248Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Irwinville, GAThe acft reportedly suffered a loss of power during aerial application. A forced landing was attempted in a field and collided with a tree. The cause of the loss of power was undeterminedNTSB NYC85LA211Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Del Mar, NYThe plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a…NTSB MIA85LA232Accident · No injuriesLimited investigationFinal reportBell 206A · Sarasota, FLThe helicopter plt landed the helicopter on a wood decked landing dolly. After landing he reduced the collective pitch control full down and reduced the throttle to idle. At the time of landing the wind was on the nose of the acft. Shortlyafter landing the…NTSB MIA85FA234Accident · Serious injuriesField investigationFinal reportCessna C-172M · Immokalee, FLThe acft had departed from the north-south oriented grass strip for a local flt and was returning to land toward the north. On short final the acft collided with an umarked power transmission line aprx 100 ft AGL and 0.25 mile south of the apch end of the…NTSB LAX85LA351Accident · No injuriesLimited investigationFinal reportCessna 172P · Saint Helena, CADuring a local personal flt, the plt said the 'engine began to run rough a shake violently.' With not enough power to maintain altitude, the plt elected to make an emergency landing in a field, however, overran the field after touchdown and collided with…NTSB LAX85LA347Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hollister, CAThe plt and gnd witnesses reported that during the takeoff roll, the nose gear collapsed, followed by the main landing gears. Post-accident investigation disclosed the landing gear control handle was in the down position. All of the landing gear…NTSB FTW85LA320Accident · No injuriesLimited investigationFinal reportCessna 172N · Sallisaw, OKThe plt stated he had an electrical failure and elected to make a precautionary landing at Sallisaw municipal arpt. Equipment was on the rwy and the plt elected to land on a grass strip next to the rwy. He touched down and during rollout thought he could not…NTSB CHI85LA345Accident · No injuriesLimited investigationFinal reportCessna 140 · Almont, MIAfter takeoff and about 300 ft AGL the plt said his eng stopped briefly restarted then stopped. He landed in a cow pasture and to avoid hitting the cows landed hard on the left gear and engine. The acft then nosed over inverted.NTSB ATL85LA247Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersburg, TNDuring the third takeoff the pilot failed to obtain and maintain flying speed and crashed in a field off the departure end of the ag strip.NTSB SEA85LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Bellingham, WAThe plt, who was unfamiliar with the area, was given directions & traffic pattern info to the meadows mist arpt, a a pvt/charted strip near Bellingham, WA. She came upon a similar grass strip in that area with a parked acft on it. Thinking this uncharted…NTSB NYC85LA209Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Carthage, NYAccording to the pilot,while climbing to cruise, the engine began to run rough; however it did not quit. The pilot decided to return to the field for a precautionary landing. While turning onto final approach, the engine quit and the pilot attempted to glide…NTSB MKC85LA187Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Ottumwa, IAN27492 collided with utility wires which cross the des moines river and crashed into the river.NTSB MKC85LA184Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Oakley, KSN8541S collided with a fence and crashed while attempting a forced landing. The plt reports that it took longer than expected to dispense his chemical load and he was critically low on fuel when he departed the working area for the arpt. He got to within 2…NTSB MKC85LA183Accident · No injuriesLimited investigationFinal reportCessna A188B · Menlo, KSPlt reports that the eng gradually lost power during a swath turn around. A landing on a nearby road appeared possible but the eng quit and the acft crashed in a corn field. Post accident examination by an FAA inspector failed to reveal any evidence to…NTSB MKC85FA182Accident · 1 fatalField investigationFinal reportRonald Houk RD-1 · St. Charles, MOThe home built gyrocopter was being flown by the owner/builder/designer who had an airplane, single-eng, land rating. Shortly after the gyrocopter took off, the eng was operating at a high RPM when a witness heard a pop/noise. Subsequently, the gyrocopter…NTSB FTW85LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · May, TXThe plt stated the eng RPM dropped to 1500 during level cruise flt at 4200 ft MSL. He could not regain pwr. He diverted the flt and attempted to reach the brownwood, TX, arpt but did not have sufficient alt. A forced landing was made in a rugged, heavily…NTSB DEN85LA218Accident · No injuriesLimited investigationFinal reportDowner Aircraft Industries REP. Seabee RC-3 · Haugan, MTThe plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest…NTSB DEN85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ruidoso, NMAcft was 20 lbs over the max gross weight. Plt said he aborted the first takeoff due to a rough running eng. The plt performed a runup and attempted a second takeoff which was aborted again due to rough running eng. The acft ran off end of rwy and struck a…NTSB CHI85FA344Accident · No injuriesField investigationFinal reportLearjet 23 · Madison, WIThe plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off…NTSB BFO85FA068Accident · 4 fatalField investigationFinal reportPiper PA-20-125 · Culpeper, VAWitnesses stated that the takeoff roll began about 2000 ft from the departure end of the 2300 ft sod rwy. The a/c lifted off from a 3-point attitude and climbed at a high angle of attack, 'mushing along' until it fell off on the rt wing and struck the ground…NTSB BFO85FA067Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Woodbridge, VAThe acft departed saratoga springs, NY, en route to manassas, VA. Wx was VFR and as the acft approached gaithersburg, MD, at 2132 LCL the plt contacted dulles apch for vectors through the area to manassas. The acft was issued a heading to manassas. Shortly…NTSB NYC85LA208Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Groton, CTEnstrom F28F, N8623X was performing auto rotation at Groton-new london, Connecticut when a loss of power was experienced, the student pilot was at the controls and entered auto rotation with the understanding that it would terminate in a power recovery. After…NTSB MIA85LA230Accident · No injuriesLimited investigationFinal reportCessna 177 · Vieques, PRThe CFI and student plt utilized a homemade dipstick to check the fuel tanks & determined they had about 8 gals of fuel in the tanks. About 30 minutes after takeoff the eng failed and all restart attempts were negative. The acft was ditchedin about 25 ft of…NTSB MIA85LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jacksonville, FLPilot stated that while enroute he experienced an electrical system failure. During approach to the airport he could not get the landing gear to extend and he made a gear up landing. As the aircraft was raised after the accident the landing gear extended and…NTSB MIA85FA233Accident · No injuriesField investigationFinal reportCessna C-150 · Kissimmee, FLThe acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely.NTSB LAX85LA345Accident · No injuriesLimited investigationFinal reportAerospatiale SF3130 · Buckeye, AZDuring a hover in a confined area the plt misinterpeted his passg signal to move to a diferent location as a signal that the tail rotor was in danger. The plt used abrupt control movements that resulted in the toe of a skid hooking into a wire fence. The…NTSB LAX85LA344Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Big Bear City, CAOn August 12, 1985, a Bell 47G2 helicopter collided with a yucca tree and rolled over during a landing near Big Bear City, CA. The acft sustained substantial damage and the plt and his two passengers were not injured. The purpose of the flight was a aerial…NTSB FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…NTSB FTW85LA316Accident · No injuriesLimited investigationFinal reportCessna 150M · Mcallen, TXThe acft lost eng pwr while on downwind for rwy 12. The plt was cleared to land on any rwy and he chose rwy 36. (The south end of this rwy joins rwy 13 at midfield). However, a strong tail wind prevailed and the acft was high and fast. It touched down on rwy…NTSB CHI85LA346Accident · No injuriesLimited investigationFinal reportCessna 177 · Hillsdale, MIThe acft contacted trees during a forced landing following fuel exhaustion. The acft was in cruise flt when the plt noted the fuel gages indicated a low fuel state. He had turned toward an arpt which was closer than his destination and the eng quit. He…NTSB BFO85FID03Accident · Minor injuriesFinal reportBeech A36 · Roanoke, VAThe plt had boarded two pax and started the eng. When he attempted to taxi he realized he still had a chocked gear. Leaving the eng running he got out and found the nose gear chocked. When he removed the chock, the acft which was parked on an incline began to…NTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…NTSB ATL85LA245Accident · No injuriesLimited investigationFinal reportCessna T188C · Athens, ALThe acft experienced a gradual loss of pwr followed by an in-flt fire which lead to an off arpt forced landing. During the forced landing ihe acft collided with trees and was destroyed by fire.NTSB ANC85LA151Accident · No injuriesLimited investigationFinal reportCessna C-207 · Mountain Villag, AKThe pilot-in-command was aware of the weather he was operating in and intended to fly through a locally well known pass. He misidentified the pass and found himself in a narrow valley. There was insufficient width to effect a 180 degree turn and the rising…NTSB SEA85LA195Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Vashon, WAPlt reported a loss of power on initial climb from takeoff; stalled acft while manuvering for best lndg place in orchard. Fire broke out as occupants evacuated the act. Consuming most of the cabin/fuselage. Investigation failed to reveal cause of power loss.NTSB SEA85LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Pocatello, IDUpon arrival in the vicinity of his destination the plt commenced a reduced pwr descent while in conditions which were conducive to carburetor iceing. During the descent the plt applied carburetor heat with a resultant drop in RPM and, apprehensive of this…NTSB NYC85LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lakewood, NJWhile returning to Lakewood airport,, power was lost suddenly. The pilot elected to land in a stand of pine and oak trees instead of landing on a busy highway. The pilot decided that the distance was too great for a glide to the airport. A post crash…NTSB MKC85LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Shawnee, KSThe commercial Balloon plt was giving a ride to three paying passengers. Plt stated that during the landing apch higher than normal winds were present so he briefed the passengers to lean against the side of the basket. He stated that he pulled the deflation…NTSB FTW85LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Falfurrias, TXThe plt experienced in-flt directional gyro problems (exessive precessing) which resulted in large deviations on either side of his planning flt path. After realizing it was inaccurate he continued using it for some of his heading info. The acft continued to…NTSB FTW85LA312Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Morton, TXAfter completing several passes, the acft was crossing a road under power lines when the propeller struck a road sign. The acft subsequently became uncontrollable and impacted in an adjacent field, flipped over and slid to a stop. The pilot stated that he was…NTSB DEN85FA214Accident · Serious injuriesField investigationFinal reportPiper PA-60-600 · Denver, COPilot in command stated that he waited aprx 90 seconds after a B-727 departed on rwy 8R due to possible wake turbulence. Plt continued to state that he used a short field takeoff procedure to climb above the flt path of the B-727. He stated that during…NTSB CHI85LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPilot had dept with minimum fuel for the 60 mi x-country flt. He overflew dest by 25 mi and after correcting course ran out of fuel 2 mi short of the aprt. While landing on a country road acft veered into a ditch.NTSB CHI85LA343Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlette, MIThe student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually…NTSB BFO85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Richmond, VAThe flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate…NTSB ATL85FA243Accident · 1 fatalField investigationFinal reportCessna 150G · Selma, ALAcft took off from sod strip on hot humid day near max weight. PIC said he used 10 degrees flaps and was airborne. At about runway mid point. When over first tree line after passing threshold acft descended. When over brown terrain acft climbed. When over…NTSB NYC85LA206Accident · Serious injuriesLimited investigationFinal reportCessna C150 · Eliot, MEAircraft collided with trees when the aircraft stalled during an attempted go around. The student pilot was on his first solo supervised flight. On landing he came in long and prior to the wheels touching down, power was added. However during the climb, with…