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 NYC88DGM01Accident · 1 fatalFinal reportHiller UH-12E · Lovely, PAThe undetermined loss of engine power while performing low level aerial application operations.NTSB MIA88LA246Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Glen Allen, MSAccording to FAA personnel while returning to land during an aerial application flt, the eng quit due to fuel exhaustion. The acft was damaged drg the forced landing.NTSB FTW88LA143Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dalhart, TXAs the ag airplane tried to level off at the start of the spray run, it continued the descent into the corn and flipped forward to the inverted position. The elevation in the area was 4100 ft MSL and the density altitude was 5000 ft.NTSB DEN88LA175Accident · No injuriesLimited investigationFinal reportBraswell Scirroco MJ5-K2 · Hurricane, UTThe plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA…NTSB DEN88LA172Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Guffey, CONTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…NTSB CHI88LA191Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · St. Charles, MIThe pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…NTSB BFO88LA072Accident · No injuriesLimited investigationFinal reportPiper PA-30-160R · Chantilly, VAThe instr & stu plt were doing a practice landing on rwy 27 at the front royal airport when the acft landed hard and bounced about 20 ft high. A go around was made, however, the landing gear would not retract. After two flyovers of the arpt it was confirmed…NTSB BFO88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisonburg, VAThe plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made…NTSB SEA88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter.NTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.NTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…NTSB NYC88DHJ01Accident · Serious injuriesFinal reportStolp Starduster SA-300 · Shirley, NYThe plt rprtd that the acft's eng lost power as he was departing from rwy 24. He said he turned left to land on rwy 15, then the eng restarted again, so he decided to land on rwy 24. Also, he rprtd that as he was banking to the left in the traffic pattern,…NTSB MKC88FA147Accident · 2 fatalField investigationFinal reportMooney M20C · Missouri City, MOThe co-owner of the acft stated he had experienced a fuel flow pblm while flying to the (ojc) arpt, where pax (one of them was a co-owner) were to board. He stated he advzd the other owner of the pblm, but no corrective action was taken. The acft was then…NTSB MIA88LA245Accident · No injuriesLimited investigationFinal reportStanford Monofly · Jacksonville, FLFlt experienced total loss of engine power while on a downwind position for landing. The runway could not be reached and a forced landing was made in trees. The fuel pump was mounted directly to the engine block and auto fuel was being used. After the…NTSB MIA88FA244Accident · Serious injuriesField investigationFinal reportCessna 150M · Pahokee, FLThe acft crashed while the plt was attempting a touch and go landing at Pahokee airport, Pahokee FL. The plt stated that when he landed on runway 17, the acft bounced. As he was attempting a go around, he lost control. The acft stalled, broke left, and…NTSB LAX88LA279Accident · No injuriesLimited investigationFinal reportMooney M20E · Visalia, CAThe pilot removed the vacuum pump from the engine prior to the flight because of an internal failure in the pump. The pilot did not install a cover plate on the accessory mounting hole vacated by the pump. After takeoff on the local flight, the pilot noticed…NTSB LAX88DUM06Accident · No injuriesFinal reportHiller UH12E · Bard, CADuring helicopter aerial application, engine power was lost. Plt applied back cyclic and tail rotor contacted terrain, followed by hard landing. Investigation revealed less than useable fuel remaining.NTSB DEN88LA173Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Watkins, COThe new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another…NTSB CHI88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WINTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.NTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.NTSB ATL88LA225Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · N. Myrtle Beach, SCThe plt reported that he made a low pass over the banner staging area to drop a banner; the release mechanism in the cockpit failed to operate and the banner remained in tow. Xwind conditions blew the banner into another banner on the ground which was…NTSB ATL88DLT01Accident · 1 fatalFinal reportVan RV-4 · Ashland City, TNNTSB ANC88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,…NTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…NTSB MKC88LA146Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Washington, IAWhile enroute the PIC rptd a loss of eng pwr. The PIC stated in his rpt that having passed Washington, IA, he switched fuel tanks to draw fuel from the lft tank which indicated 1/2 full. Shortly after switching, the PIC stated the tank went empty. The PIC…NTSB MIA88WA251Accident · Minor injuriesForeign investigationPiper PA-31-325 · El Porvenir, PanamaNTSB MIA88LA243Accident · No injuriesLimited investigationFinal reportCessna 180J · Pahokee, FLThe plt stated that he was attempting a wheel landing. On rollout he 'hit' the brakes. The acft nosed over and came to rest inverted.NTSB MIA88LA242Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Greenville, MSThe pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.NTSB LAX88FA278Accident · 1 fatalField investigationFinal reportCessna T-210 · Brea, CANTSB FTW88LA142Accident · No injuriesLimited investigationFinal reportBeech A36TC · Vega, TXUnreported propeller strike.NTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.NTSB CHI88FA190Accident · 2 fatalField investigationFinal reportMcdonnell Douglas 269B · Braceville, ILConducting maneuvering flight the PIC failed to monitor the helicopter systems and allowed the main rotor RPM to decay to the point where it would not produce enough lift to sustain flight.NTSB CHI88DEI03Accident · Minor injuriesFinal reportPiper PA-28-140 · Salem, OHThe airplane engine failed to respond when the throttle was advanced during the recovery from a practice forced landing. The airplane struck wires while attempting to reach a suitable landing area during the resulting forced landing. The wires did not break;…NTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…NTSB NYC88LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsville, PAEngine power loss due to fuel starvation which resulted in an emergency landing in a field.NTSB MIA88IA240Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Pensacola, FLThe captain stated that he crossed the final approach fix at 3000 feet, continued the approach, touched down at 140 knots at the end of the touchdown zone, but could not stop the acft and ran off the end of runway 16. According to tower personnel and…NTSB CHI88LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Cheboygan, MIShortly after departure, when the aircraft was approximately 30' in the air, the aircraft's right wing 'dropped hard'. The pilot attempted remedial action, but was unable to regain control of the aircraft before the right wing tip struck the ground. The…NTSB CHI88LA185Accident · No injuriesLimited investigationFinal reportCessna 172N · Xenia, OHNTSB CHI88FAMS2Accident · Serious injuriesMissing aircraftFinal reportMooney M20K · Racine, WIEngine failure due to fuel starvation.NTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…NTSB BFO88LA070Accident · No injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEThe plt was in the process of picking up a banner when the aircraft stalled and crashed into a wooded area. The banner was picked up at an airspeed of 80 mph and the acft altitude was increased to 250 ft AGL. The pilot reported that the wings of the acft…NTSB ATL88LA223Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Laurens, SCThe plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.…NTSB ANC88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.…NTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…NTSB MKC88LA143Accident · No injuriesLimited investigationFinal reportCessna 188 · York, NEEn route to perform an aerial application operation, the plt said he experienced a partial power loss followed by complete power failure. He attempted an emergency ldg in a farm cornfield, substantially damaging the acft. An on scene investigation by the FAA…NTSB LAX88LA276Accident · Serious injuriesLimited investigationFinal reportRaven RX-6 · Sun City, CAThe pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…NTSB LAX88FA277Accident · 1 fatalField investigationFinal reportCessna 414A · Big Pine, CAThe pilot intentionally flew over an area of high terrain in which he failed to maintain the proper altitude and he delayed his decision to reverse course. A contributing factor was the pilot's improper in-flight decision.NTSB DEN88LA164Accident · No injuriesLimited investigationFinal reportStinson 108 · Lordsburg, NMDuring takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10…