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 NYC85LA192Accident · No injuriesLimited investigationFinal reportCessna P206D · Limerick, MEDuring the short field approach, as the aircraft passed over the tree line, the sink rate suddenly increased. The pilot applied power and increased the pitch but the aircraft touching down hard and bounced. A second touch down was made and as the nosewheel…NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB LAX85LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Anza, CADuring a cross country personal flight, the aircraft experienced fuel exhaustion for undertermined reasons and nosed over during the subsequent forced landing in a soft sand and scrub brush covered area. Prior to departure of the flight (a measured straight…NTSB LAX85FA325Accident · 2 fatalField investigationFinal reportCessna 150L · Goleta, CAAt 0242 PDT, the student plt tried to call the tower for a radio check. The tower was closed, but a fss specialist heard the transmission & provided advisories. Subsequently, the student plt took off with a passenger aboard. Shortly, after takeoff, the acft…NTSB DEN85LA204Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Logan, NMThe plt lost directional control while landing on a gravel road. Subsequently, the acft was damaged when it veered to the right & went into a ditch.NTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.NTSB DEN85FA196Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7 · Brighton, COA hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…NTSB CHI85LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt was attempting his first solo landing and had difficulty correcting for the crosswind. When he was over the threshold, he initiated a go-around. The acft drifted to the left of the rwy and collided with trees 200 ft from the rwy centerline.…NTSB CHI85LA309Accident · No injuriesLimited investigationFinal reportCessna 150D · Lincoln, ILWhen the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.NTSB BFO85LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Charlottesville, VAThe student plt entered a left base for rwy 03, and according to a witness, made a hard landing on the main gear. After touchdown, the nose gear collapsed and the acft slid approximately 80 feet down the rwy.NTSB BFO85FA061Accident · Serious injuriesField investigationFinal reportCessna 152 · Mechanicsville, MDAfter completing several low altitude passes over the family business, the student pilot extended 10 degrees of flaps and pulled the power back to slow the airplane in order to lengthen his viewing time. According to the pilot, after the accident, at between…NTSB ANC85FA135Accident · 2 fatalField investigationFinal reportStinson SR6 · Port Lions, AKThe pilot continued the flight into less than visual conditions; became spatially disoriented and crashed while the aiplane was out of control.NTSB LAX85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Kahului, HIOn July 22, 1985, a Cessna 3100, N6740T experienced a loss of engine power while on final approach to the Kahului arpt in maui, Hawaii. The ac sustained substantial damage and the plt received minor injuries. The ac has a fuel capacity of 90 gal useable. The…NTSB LAX85LA327Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe plt and a gnd witness reptd the acft touched down, main wheel first, in a smooth, soft manner. Upon touch down the nose gear collapsed. The acft slid for 200 ft before coming to rest. Examination of the nose gear assembly disclosed the gear actuator rod…NTSB LAX85FA328Accident · 2 fatalField investigationFinal reportCessna 150G · Columbia, CAOn July 21, 1985 at about 2115 hours p.d.t., Cessna 150, N2209J, registered to laurence p. thompson, auburn, California,and operated by sunshine flyers, inc., auburn, California, crashed after colliding with some trees about 1 mile north northwest of Columbia…NTSB DEN85LA198Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Durango, COThe plt reported that prior to landing, the UNICOM operator reported that the wind was from the northwest at 10 to 20 KTS & was gusty. Also, he said that while on base leg, he encountered a severe downdraft. He stated that he applied pwr & retracted the flaps…NTSB DEN85LA195Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Riverton, WYThe plt was crop spraying a field in a Schweizer ag-cat acft when the left landing wire broke. The plt returned to Riverton, WY. During the landing roll, in attempt to stop the acft as soon as possible, he inadvertently applied the brakes too hard, causing…NTSB DEN85LA193Accident · No injuriesLimited investigationFinal reportCessna 182P · Missoula, MTThe pilot lost directional control during the touchdown phase of landing. The aircraft was substantially damaged when it veered off the runway and nosed over in the soft dirt.NTSB CHI85LA312Accident · Minor injuriesLimited investigationFinal reportFrank H Marchetti Avenger Gyro Plane · Shelbyville, ILThe gyroplane was running up on the end of the rwy when the varieze landed on top of him, striking thr rotor system. The varieze flew a non=std flt pattern & did not make a radio call in the traffic pattern.NTSB CHI85LA308Accident · No injuriesLimited investigationFinal reportCessna 150M · Mt Pleasant, MIThe student plt was on a solo x-country flt between maple grove arpt & houghton lake arpt. During the flt, the plt requested radar assistance to locate houghton lake. Due to her solo student status & the close proximity of Mt Pleasant arpt, she was advised to…NTSB CHI85LA306Accident · No injuriesLimited investigationFinal reportCessna 120 · Hart, MIThe pilot on the return leg of a x.country flt failed to visually check his fuel supply and selected an empty tank for takeoff. On liftoff the engine stopped and the pilot attempted to ld on the remaining 300 ft of runway. After touchdown the acft veered off…NTSB CHI85LA305Accident · Serious injuriesLimited investigationFinal reportKauffman BD4 · Acme, MIThe plt was on the second flt of newly certificated acft and had been airborne aprx 10 minutes when a total loss of pwr was experienced. Unable to return to the arpt the plt landed the acft in an open fld. During the landing roll the acft struck a road…NTSB SEA85LA175Accident · No injuriesLimited investigationFinal reportCessna 150C · Chesaw, WAThe student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over.NTSB NYC85LA188Accident · No injuriesLimited investigationFinal reportLake LA-4 · Sidney, MEAccording to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…NTSB NYC85LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJAccording to the pilot, the aircraft floated during the flare to touchdown. The pilot applied power for a go around, but the aircraft did not clear some bushes at the end of the runway. The aircraft landed straight ahead in a field and rolled about 300 feet…NTSB NYC85FNC06Accident · Serious injuriesFinal reportPiper PA-11 · Moultonboro, NHThe 65 HP acft took off from a cove and during a turn at about 150 ft AGL the acft nosed dwn after rolling rt. The acft struck the water in a steep nose down attitude. According to witnesses, the bng was running normally during the climb and descent. No…NTSB NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…NTSB LAX85LUJ01Accident · Minor injuriesFinal reportAerotek Pitts S-1 · Page, AZThe acft contacted the ground during an attempted go-around. The plt had tried to perform a x-wind landing.NTSB FTW85LA295Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · South MarshThe plt was initiating a takeoff from a hover off an offshore oil rig. As he lowered the nose for takeoff, he heard a loud noise emit from the tailboom area & the acft began rotating to the right. The plt continued to apply pwr and autorotated to the water.…NTSB FTW85LA293Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Graford, TXThe pilot arrived in the mineral wells, TX, area, his intended destination, and stated he couldn't see the airport due to the rotating beacon and runway lights not operating. Notamed to this effect, however, the airport supervisor stated that to the best of…NTSB DEN85LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalispell, MTThe plt was returning from a local pleasure flt, it was a hot day. The plt said that he inadvertently leveled the acft aprx 10 ft high. He said the acft stalled causing a hard landing. The impact caused substantial damage to the acft.NTSB CHI85LA310Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Milford, MIThe pilot made a 'steep approach' to a hover over a boat channel and then ld in the yard of a residence. He then picked up a 270 id pax flew a short flt and was refueled with 25 gals of fuel. After another short flt the pilot returned to the channel and…NTSB CHI85LA307Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Sheboygan, WIThe acft collided with a ditch during a forced landing following a loss of power in cruise flt. The plt reported he switched the fuel selector from the left to the right tank, & after aprx 3 minutes, a total loss of power was experienced. He stated that…NTSB CHI85LA304Accident · Serious injuriesLimited investigationFinal reportCessna 210H · Burlington, WIPilot estimated 15 gals of fuel at preflt. After 15 min grd delay due to traffic pilot tookoff and climbed to 2,500'MSL. After cruising 22 nmi the engine quit due to fuel exhaustion. During attempt to ld in corn field pilot attempted to stretch his glide and…NTSB ATL85LA222Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Williamson, GAThe plt of the powered glider reported that during an apch to land, the acft encountered a downdraft & landed hard. The landing gear was damaged as well as the prop, eng cowling & oil cooler.NTSB NYC85LA190Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Rhinebeck, NYThe acft was moving at about 30 mph when the gear collapsed. According to the plt, the landing gear leg fitting failed causing the gear to collapse.NTSB NYC85LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Stowe, VTDuring cruise flt, the plt heard a loud knocking coming from the eng and a decrease in oil pressure. During the landing in a fld, the landing gear collapsed and the acft ground looped. Examination of the eng disclosed that the hydraulic lifters of three of…NTSB MKC85LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Forest City, IAShortly after the acft took off with 4 skydivers on board, its eng seized at an alt of about 300 to 400 ft. the plt selected the best available area to land which was a field of tall corn on rolling terrain. During the emerg landing, the acft nosed over.…NTSB MKC85LA162Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, NEN4848Q was loaded to max gross wt and was taking off on a 2,350 ft, turf rwy. The plt said the wind was light and favored rwy 29 before takeoff. The density alt was about 2,500 ft. the plt said the acft did not seem to be developing quite the power it should…NTSB MKC85FA175Accident · Serious injuriesField investigationFinal reportCessna 150L · Lee'S Summit, MOThe plt discharged one passenger without stopping the eng & motioned to the next passenger (his wife) to come around from the front of the airplane. Subsequently, his wife walked into the propeller & received a serious injury to her arm.NTSB MIA85LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Frostproof, FLThe instructor plt (CFI) reported that while cruising at 2000 ft, the acft eng began losing power. He elected to land on a narrow highway that was bordered by trees. He stated that during the landing, the wind blew the acft off the asphalt surface, the nose…NTSB LAX85LA334Accident · No injuriesLimited investigationFinal reportMooney M20A · Compton, CAThe student plt had a total of 36 flight hrs which included 9.4 hrs in the monney acft. He had been authorized by his CFI, who flew with him the preceding day, to practice landing. On the student's first attempted ldg, he touched down hard & began porpoising.…NTSB LAX85LA326Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Grand Canyon, AZThe preparing for an air taxi, sightseeing flight, the PIC performed a preflight inspection of the acft & failed to observe that the rt main fuel tank was nearly empty. Five(5) min after takeoff the rt eng's main tank fuel supply was exhausted & the eng lost…NTSB LAX85LA324Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · San Andreas, CAThe plt took off on a 2 hr flt with about 6 hrs of fuel on board. On several occasions during the flt, he repositioned the fuel selector handle. He stated that when he made a very shallow turn to the right, near his destination, the eng suddenly lost power.…NTSB FTW85LA292Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…NTSB CHI85LA303Accident · No injuriesLimited investigationFinal reportBell 206BII · Farmington, MNDuring maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over.NTSB CHI85FA301Accident · 1 fatalField investigationFinal reportBell 47G2A1 · Brook, INThe helicopter contacted the terrain in a flat attitude and rolled over during an autorotative landing. A witness stated an autorotation was entered at 800 ft AGL during which the plt made a 360 deg descending turn. An application of pwr was heard at an alt…NTSB ATL85FLT09Accident · Serious injuriesFinal reportCessna 152 · Memphis, TNThe acft nosed over during a forced landing following a loss of pwr. Purpose of the flt was to practice night takeoffs and landings. On the fifth takeoff, at aprx 200 ft AGL, a total loss of pwr was experienced. The acft contacted an embankment during the…NTSB SEA85LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Lebanon, ORThe plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor.NTSB SEA85LA173Accident · No injuriesLimited investigationFinal reportCessna 180G · Battle Mountain, NVWhile landing at Battle Mountain to refuel, the left main gear collapsed. The wind was reported to be from 360 deg a 18 gusting 30 KTS.