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 LAX88FA023Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Red Bluff, CAThe pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.…NTSB LAX88DUQ01Accident · 1 fatalFinal reportStits Elkins 85 · Camarillo, CADuring the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the…NTSB FTW88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brownsville, TXWhile executing a single engine ILS approach to a touch and go landing, the CFI pulled the mixture control on the right engine. Upon landing the pilot applied full power to both engines but the right engine did not respond. About 2 ft above the rwy the…NTSB FTW88LA015Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Covington, LADuring initial climb from takeoff, the left engine failed for unknown reasons. The plt stated that right rudder and aileron inputs were ineffective to stop the acft from rolling left and the acft contacted the ground as he was retarding pwr on the right eng.NTSB FTW88LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Brownsville, TXDuring initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and…NTSB FTW88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Brownsville, TXWhile circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage.NTSB DEN88LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Timberon, NMOn takeoff with a 10 to 15 knot tailwind and 10 degrees of flaps, a 20 degree turn was attempted at 60 feet AGL. The pilot stated a downdraft forced the aircraft back to the ground. The aircraft struck a woodpile and several small trees. Post-crash fire…NTSB CHI88LA016Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Union, ILThe glider was approaching to land when, according to the pilot, he noticed the aircraft was descending 'too fast' and his airspeed was 'too slow'. The pilot then realized he wasn't going to make the runway and decided to land the glider in a nearby field.…NTSB BFO88LA006Accident · Minor injuriesLimited investigationFinal reportCessna U-206 · Front Royal, VAThe aircraft was involved in a midair collision with N756KP, a Cessna U206 aircraft, while both aircraft were on the final approach to runway 27 at the uncontrolled Front Royal, VA airport. Excellent VFR weather prevailed with 15 miles visibility reported.…NTSB ANC88LA016Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Alexander Lake, AKThe relatively inexperienced private pilot attempted to land his float equipped airplane with a tailwind and gusty winds in choppy water conditions. He lost control of the airplane and it was substantially damaged.NTSB NYC88LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Pepperell, MAA student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…NTSB NYC88LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mansfield, MAThe Schweizer SGS-2-33A was in the traffic pattern with a student pilot and flight instructor. In the right turn from base to final, the nose dropped and control was lost. The flight instructor took control of the aircraft, and regained control, however,…NTSB MIA88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Titusville, FLAfter a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…NTSB MIA88LA018Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Key Colony Bch., FLThe plt stated that he did not check the fuel system for contaminates after refueling but an eighteen minute flt after refueling was uneventful. He then landed the helicopter, remained on the ground aprx 20 minutes, performed a walk around insp, again without…NTSB LAX88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CADuring a local flt while practicing touch and go landings, the plt lost control of the acft during the landing rollout. The acft groundlooped to the left, exited the rwy and nosed down.NTSB LAX88LA022Accident · No injuriesLimited investigationFinal reportCessna 402B · Avalon, CAOn landing the pilot reported he heard a loud bang and the aircraft veered to the right. The pilot corrected to the leftby applying left brake. The aircraft returned to the center of the runway; however, it began to skid. The pilot realized that he was…NTSB FTW88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mckinney, TXDuring flare/touchdown with full flaps the aircraft bounced. The student pilot in an attempt to go-around failed to retract the flaps. The aircraft stalled contacting some trees and subsequently the ground, damaging the left wing, right wing, and the…NTSB DEN88LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Greeley, COThe CFI was instructing the private rated plt in simulated forced landings. The plt reported that after a full stop landing, the aircraft would not turn properly to the right, and she suspected brake system failure. The CFI took control and attempted to taxi…NTSB ATL88LA026Accident · No injuriesLimited investigationFinal reportPitts S2A · Ramseur, NCThe pilot lost directional control while making a normal landing. The pilot did not report a mechanical problem. The ground loop cause substantial damage to the aircraft's undercarriage.NTSB ATL88FA020Accident · 3 fatalField investigationFinal reportBeech B24R · Louisville, KYDrg tkof fm rwy 19, the plt transmitted 'we have a door open.' Twr psnl clrd him to lnd on any rwy, but he stated againthat a door was open. Again, twr psnl clrd him to lnd on any rwy. No otr radio calls were recd fm the acft. Svrl personssaw the acft at low…NTSB SEA88FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Colville, WAAlthough the recently certificated private pilot was not checked out by the fixed base operator for night flight and had been warned to return before sunset, he departed the airport during dark night conditions. Witnesses reported observing the aircraft climb…NTSB LAX88FA020Accident · 1 fatalField investigationFinal reportCessna 208A · Fairfield, CAPilot's encounter with severe turbulence which precipitated a loss of aircraft control.NTSB FTW88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Caney, TXAcft took off in marginal VFR conditions on a pipeline patrol flt. En route, the plt encountered deteriorating wx conditions and experienced a rough running eng, due to what he suspected was carb ice. His attempts to remedy the roughness were unsuccessful and…NTSB FTW88FA011Accident · 1 fatalField investigationFinal reportCessna 172M · Midway, TXThe plt (a co-owner) was on the 1st flt of the acft after its 150 HP Lycoming O-320 eng had been replaced with a 180 HP Lycoming O-360 eng. He took off at about 1115 CDT. The flt progressed w/o rprtd incident until 1437 CDT, when the plt stated the acft was…NTSB FTW88FA009Accident · 2 fatalField investigationFinal reportCessna 172RG · Llano, TXThe pilot departed lubbock, Texas in VFR conditions. As the flight progressed the ceiling and visibility deteriorated and the pilot encountered instrument meteorological conditions. No evidence was found to indicate that the pilot obtained a weather briefing…NTSB CHI88FA010Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Oshtemo Townshp, MIThe aircraft was at cruise altitude (9,000 feet) for approximately 20 minutes when the pilot reported the loss of right engine power. Chicago ARTCC reported the closest airport was kalamazoo, 28 miles west. The aircraft began to descend and at 0330:53 chicago…NTSB BFO88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Churchton, MDThe plt rprtd that after searching unsuccessfully for a wind sock & getting no reply on UNICOM freq, he made an apch to rwy 16. Later, he saw the wind sock about half way down the rwy near a building. Drg the apch, he noticed he was high & put the acft in a…NTSB ATL88LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Wartburg, TNThe aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report.NTSB ATL88LA021Accident · No injuriesLimited investigationFinal reportCessna 172P · Swainsboro, GAThe acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…NTSB MIA88LA017Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Madison, MSThe plt stated that during the landing roll the acft began to veer off towards the left side of the rwy. Full rt rudder would not correct this. The acft then left the rwy, ground looped, & as a result the rt main gear collapsed & the tailwheel separated from…NTSB MIA88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ft. Myers, FLAccording to a witness the acft was taxiing slowly but at a higher than normal RPM. When the acft was stopped in the runup area, the right main landing gear caught on fire burning the bottoms of both wings. Examination of the brakes revealed that the linings…NTSB LAX88LA021Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Chino, CAThe pilot and passenger both stated that the engine lost all power during the final approach for landing. The passenger switched the fuel tank selector from the left to the right tank. There was not time to attempt a restart. He then raised the landing gear…NTSB FTW88LA010Accident · No injuriesLimited investigationFinal reportCessna 150L · Lancaster, TXWhile rtrng fm a x-country, the student bcm disoriented & reqd assistance. Redbird twr ctlr adzd dallas-ft worth TRACON that the plt was lost & needed a beacon identification. A few min later, the acft's location was determined & the ctlr at redbird relayed a…NTSB DEN88LA013Accident · No injuriesLimited investigationFinal reportBeech C45G · Salt Lake City, UTWhile conducting the last landing at the completion of a revenue freight hauling flt the acft departed the side of the runway separating the left main landing gear and damaging the left wing and number one engine. The plt stated that the landing lights would…NTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…NTSB NYC88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Beverly, MAThe plt rprtd that drg an NDB apch, the acft 'broke out slightly above minimums' & that he maneuvered to land from a close-in, base leg. He stated that drg a left turn to final apch, the left eng began losing power. Rprtdly, there was a lack of response to…NTSB MKC88LA014Accident · Serious injuriesLimited investigationFinal reportNational Balloon 752 · Ankeny, IADuring a promotional balloon flt, the plt stated that on an approach to lnd the basket drifted into a large hay bale. The basket tipped and the plts ankle was broken when caught between the basket and a propane tank.NTSB MIA88FA012Accident · Serious injuriesField investigationFinal reportCessna 210M · Jacksonville, FLDuring a part 135 on-demand air taxi cargo flt, the plt reported an eng malfunction when the acft was aprx 15 miles sw of the arpt while on apch to land. The flt continued & the plt then reported that the eng quit & the flt was 5 miles sw of the arpt. A…NTSB DEN88LA012Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Ekalaka, MTDuring the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and…NTSB DEN88FA014Accident · 1 fatalField investigationFinal reportCessna 340A · Bailey, COThe aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…NTSB ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB ANC88LA010Accident · No injuriesLimited investigationFinal reportCessna A185 · Karluk, AKThe pilot arrived late and the tide had come in at the beach in kanatak bay. By the time he commenced his takeoff attempt, the usable area had diminished considerably. The right main gear caught in the surf and the airplane inverted in the water.NTSB MKC88LA010Accident · No injuriesLimited investigationFinal reportCessna 182 · Atwood, KSThe PIC said that he did an engine runup and allowed the engine to run about 6 additional minutes before commencing the takeoff. The PIC said that upon reaching 100 feet altitude in the takeoff sequence, he observed a decline in engine revolutions per minute…NTSB FTW88LA008Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Lapra, TXUpon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly…NTSB CHI88FA008Accident · 4 fatalField investigationFinal reportCessna 310 · Brownton, MNAcft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…NTSB LAX88LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Carpenteria, CAThe pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses…NTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.NTSB CHI88LA006Accident · No injuriesLimited investigationFinal reportCessna 150J · Springfield, ILWhile taxiing back to the parking ramp, after a short instructional flight, the student and flight instructor were looking ahead into the parking area for a vacant parking place. While they were searching for a place to park, the right wing of the aircraft…NTSB SEA88LA010Accident · No injuriesLimited investigationFinal reportCessna 150-M · Myrtle Creek, ORA loss of power occurred shortly after takeoff due to fuel exhaustion. A field was chosen for the off airport landing. During the landing rollout the aircraft struck a fence and raspberry bushes, collapsing the nose gear.