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 ATL84LA226Accident · No injuriesLimited investigationFinal reportBell 204 UH 1B · Tams, WVAn over gross takeoff was attempted from a 500 ft long zone. Translational lift was not achieved and rotor RPM deteriorated. The helicopter collided with trees, crashed & burned. The plt stated that the wind may have shifted during his takeoff.NTSB ATL84FA225Accident · 1 fatalField investigationFinal reportde Havilland DHC-1B · Greenwood, MSWitnesses observed the acft become airborne and accelerate low over the rwy. At the end of the private strip the acft entered a 30 to 40 deg nose high attitude climbing to aprx 1,000 ft. the acft then rolled right as the nose dropped and continued to roll…NTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…NTSB MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.NTSB MKC84LA222Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stanford, ARWhen the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.NTSB MKC84FA221Accident · 1 fatalField investigationFinal reportMorgan T. Melton SKY Rider · West Plains, MOThe owner/bulder stated that he & his brother had been having an eng problem which they assumed was due to a vapor lock. They had installed a metal box around the electric fuel pump to insulate it from the heat of the exhaust pipe. The brother initiated a hi…NTSB DEN84LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Longmont, COShortly after lift off from a touch-and-go landing, the engine sputtered and lost power. A forced landing was performed in a field where the aircraft struck a dirt bank and nosed over. No reason was found for the power loss.NTSB ATL84LA229Accident · No injuriesLimited investigationFinal reportCessna A188B · Crenshaw, MSThe pilot acknowledged that he attempted to take off on an aerial application flt with the acft loaded above its maximumcertificated gross weight. He stated that he had previously flown with chemical loads & had not encountered problems taking off. Prior to…NTSB ATL84LA224Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · No.Myrtle Beach, SCWhen the plt extended the gear, the landing gear motor circuit breaker (c/b) popped. He reset the c/b & after a cool down period attempted to extend the gear again, but with the same results. The plt was not able to extend the gear fully down & locked with…NTSB ATL84LA223Accident · No injuriesLimited investigationFinal reportBeech 58 E · Sumter, SCAfter a long work day the pilot forgot to extend his landing gear at his destination airport and landed gear up. The pilot reported he has not slept well on the night before the accident and that his attention was diverted by another acft landing ahead of him.NTSB ANC84LA118Accident · No injuriesLimited investigationFinal reportCessna 206 · Cold Foot, AKThe acft was damaged in a forced landing on a road after the engine quit. After the accident the acft fuel system was examined by an FAA inspector. The fuel/air screen was found to be contaminated with dirt. The injector screen and the main fuel strainer was…NTSB MKC84IA220Incident · No injuriesIncident investigationFinal reportBeech C-45H · Columbia, MOThe plt reported that he was unable to get a down & locked indication on the main landing gear when arriving at Columbia. He stated that he went thru the emergency procedures & made two landing attempts but felt the gear was about to collapse & made…NTSB MKC84FCD01Accident · Serious injuriesFinal reportCessna A188B · Hesper, IAThe acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…NTSB MIA84LA208Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ocean Cay (Atlantic Ocean)Acft was ditched in the atlantic Ocean after power loss occurred. The wreckage was not recovered.NTSB LAX84LA404Accident · No injuriesLimited investigationFinal reportCessna 170B · Huntington Bch, CAThe acft departed the rwy to the left during landing. Upon contacting soft dirt the right main gear collapsed and separated from the acft. According to the plt the acft hit a rough spot and bounced. Other damages were done to the fuselage, the wings and the…NTSB LAX84FA405Accident · 2 fatalField investigationFinal reportHughes 369D · Mesa, AZThe helicopter experienced a main rotor drive system disconnect, an uncontrolled descent & subsequent inflight collision with terrain in a hilly desert area. This was the third & last in a planned series of marketing demo flts conducted for three USMC…NTSB ATL84FA222Accident · No injuriesField investigationFinal reportPiper PA-32R-300 · Rock Hill, SCThe acft was destroyed in a post flt fire after a forced landing at night in a private yard. The engine had surged and lost power during the descent through 4500 ft prior to landing. The acft had been written up for sluggishness and lack of response to…NTSB ANC84LA117Accident · No injuriesLimited investigationFinal reportCessna 180 · King Salmon, AKThe plt was making his fourth landing for a full stop in the tailwheel acft. After the tailwheel contacted the rwy, the upwind wing was raised by a crosswind. The other wing then dragged the surface & the acft partially ground looped & nosed over.NTSB SEA84LA176Accident · No injuriesLimited investigationFinal reportCessna 182D · Eugene, ORThe plt estimated that the acft had about 1 hr of fuel remaining in the tanks prior to departure. However, after he had flown about 15 min, the eng lost power & would not restart. An emergency landing was made in a meadow about 2 mi from the arpt. The acft…NTSB SEA84FA175Accident · 1 fatalField investigationFinal reportCessna 182H · Elko, NVAbout 5 min after taking off on rwy 23, the plt reported on a downwind leg of the traffic pattern. Shortly after that, the acft crashed about 2 mi south of the arpt while on a southerly heading in a left wing low attitude. During impact, the left wing tip hit…NTSB NYC84FA247Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Newcomb, NYThe flight was operating in accordance with f.a.r. part 135.the plt filed a VFR flt plan and was cruising at an altitude of 5,500 ft when clouds were encountered. The plt attempted to descend to 3,500 but collided with the santanonimountain at an elevation of…NTSB MKC84LU006Accident · Serious injuriesFinal reportRotec Rally 3 · Grand Island, NEBefore the flt, the instructor saw a thunderstorm approximatetly 20 mi north of the field, moving slowly to the south-southeast. He & the student elected to make a short flt. After taking off, they made a practice forced landing in an open field about 1 mi…NTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…NTSB LAX84LA401Accident · No injuriesLimited investigationFinal reportBeech H18S · Honolulu, HIDuring takeoff at about 50 ft AGL & 4,000 ft down rwy 4R, the right eng lost power. According to the plt, his airspeed was 105 mph & the right eng 'popped' before it lost power. He also stated that power on the left eng deteriorated after the the right prop…NTSB LAX84LA399Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Folsom, CAThe acft was observed flying down a river at a low altitude toward the main body of a lake. The acft impacted a 12 kv power line. The plt stated that he did not see the wires until an instant before impact.NTSB DEN84LA226Accident · Serious injuriesLimited investigationFinal reportCessna 172 · W Bountiful, UTThe acft was a Cessna 172 that had been converted to a 'Texas taildragger' in accordance with an approved STC. The purpose of the flt was for the plt to obtain a biennial flt review. He stated that immediately after takeoff, the eng began to progressively…NTSB ATL84LA221Accident · No injuriesLimited investigationFinal reportCessna 172K · Fayetteville, WVThe plt stated that the eng suddenly lost power as he was climbing thru about 150 ft AGL. He continued straight ahead & landed after the acft brushed the top of a small tree then hit another small tree. No reason for the loss of power was found. One of the…NTSB ANC84FA120Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cantwell, AKImpact occurred at the 3,600 ft level on a steep slope of mountainous terrain. Instrument meteorological conditions were reported by pilots as well as ground personnel in the area. Loose and unstable terrain conditions limited the investigative effort.NTSB ANC84FA116Accident · No injuriesField investigationFinal reportHelio H-250 · Fairbanks, AKThe acft nosed up after takeoff to an aprx 75 deg pitch angle in spite of nose down control input. The plt pulled off all power and the acft fell to the ground. Post accident investigation revealed that the acft was about 392 lbs over gross weight and 5.13…NTSB SEA84LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Redmond, ORThe acft collided with the ground after a in-flt main rotor blade separation during an aerial application flt. Inspection of the fracture surface of the failed blade revealed characteristics consistant with the high stress, low cycle fatigue. Lab findings…NTSB SEA84FA173Accident · 4 fatalField investigationFinal reportCessna Wren 182G-460 · Winlock, WAThe Cessna 182 was equipped with a wren conversion for stol operations. The plt took off from an agricultural field toward the southwest with 3 passengers on board. Subsequently, the acft collided with trees beyond the departure end of the takeoff area, after…NTSB NYC84LA246Accident · No injuriesLimited investigationFinal reportBeech C24R · Newmarket, NHPlt reported loss of power in flight and executed a forced landing in a wooded area. Reason for the power loss was not determined.NTSB MKC84LA219Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Chadron, NEPlt stated that while manuvering to avoid transmission wires on a small incline, his rolling pull-up was excessive, causing airspeed decay and a stall/mush. The empennage failed to clear the power lines during the mush. Acft then collided with terrain.NTSB MKC84FA218Accident · 1 fatalField investigationFinal reportEagle DW1 · Kimball, NEThe acft collided with a microwave tower 158 ft AGL while the plt was making a smoke trail to test the wind. As the plt was seen to look back along his smoke path, the acft collided with the tower. The cables supporting the twr & the twr destroyed the acft…NTSB LAX84LA398Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Tracy, CADuring the landing roll, the acft ran off the side of the rwy. The plt stated that he landed with a slight tailwind.NTSB LAX84LA397Accident · No injuriesLimited investigationFinal reportCessna 172 M · Woodland Hills, CAThe acft made a forced landing on city street after a partial power loss. The private plt was carrying passengers and had reportedly not briefed them on emergencies. He also did not fasten his shoulder harness because he did not know how to connect it. After…NTSB LAX84FA396Accident · 1 fatalField investigationFinal reportTravel Air 4000 · San Miguel, CAGround witnesses reported that this & another acft were engaged in a mock 'dogfight'; both acft were circling the accident area between 500-800 ft AGL & neither acft was negotiating any aerobatic maneuvers. The plt stated that during a descending 30 deg right…NTSB FTW84LA311Accident · No injuriesLimited investigationFinal reportCessna 175A · Daisetta, TXThe student plt on a solo flt ran off the end of the rwy during landing. FAA said the plt had not received dual instruction recently enough to be legally qualified for this flt. A report of the accident was not filed by the student.NTSB DCA84IA030Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Marietta, GAEastern airlines flt 92, a Boeing 727, N8840E, and an air force-KC-135, reg #60-0330, call sign fowl 24, were involved in a near collision while both acft were maintaining FL350. The captain of flt 92 reported that during the occurrence, the KC-135 passed…NTSB CHI84LA299Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIThe plt stated that while flaring for their 5th stop-&-go at night, a deer ran out onto the rwy. The acft collided with the deer & the left main landing gear was sheared off. The acft then veered off the rwy.NTSB CHI84LA296Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, INThe pilot stated after the accident that he performed a preflight inspection of the acft and did an engine run-up before takeoff. During climbout, at an altitude of 150 feet the plt experienced an engine failure. An emergency landing was made in trees. The…NTSB CHI84IA301Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe #2 wheel assembly separated from the acft during takeoff roll. Flt was diverted to atlanta, GA, where an uneventful landing was made. Inspection revealed the axle failure occurred as a result of fatigue crack propagation of numerous prior cracks in the…NTSB NYC84LA245Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manahawkin, NJThe acft descended out of control into trees and slid down an embankment. The plt said everything seemed normal on takeoff until the acft was put into a climb at about 93 mph at 50 ft AGL the acft began vibrating and veered about 90 degrees to the right. An…NTSB NYC84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Forrestport, NYThe acft stalled into trees near the edge of a lake and tumbled into the water after the engine quit due to fuel exhaustion at 2000 ft AGL aprx 2 miles from the lake. The plt said he should have used a dip-stick to measure the fuel in the tanks before takeoff…NTSB NYC84LA242Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Thomaston, CTThe glider made an off-arpt landing after encountering unexpected strong head winds in a rapidly changing flow of marineair. The acft cleared obtacles on final but yawed and landed in a crab condition damaging the fuselage and wing tip wheel.NTSB NYC84FFJ03Accident · Serious injuriesFinal reportRaven S55A · Lakeville, NYWitnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious…NTSB NYC84FA240Accident · 2 fatalField investigationFinal reportMBB BO-105C · Rehobeth, MAThe messerschmitt-blohm-boelkow BO-105C was on an air ambulance flt with a plt, 2 additional crewmembers (doctor & nurse) & a passenger (patient) on board. During flt, the plt radioed that he had lost power in 1 eng, then about 14 sec later, he radioed that…NTSB MKC84LA216Accident · Serious injuriesLimited investigationFinal reportAdams AB · Ballwin, MOThe plt reported that before landing, he rebriefed the passengers on the landing technique. He noted that a lady passenger seemed nervous about the landing. The plt landed in a pasture with an estimate 6 kt wind. Reportedly, the balloon made a soft touchdown,…NTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…NTSB LAX84LA427Accident · No injuriesLimited investigationFinal reportCessna TU206C · Catalina, AZThe acft ran into ruts washed out by recent rains on a private arpt. The plt reported that he circled the arpt to look for hazards. He concluded that it was ok to land. After the accident he said that he should have called the arpt operator prior to flying…