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.

NTSB SEA88LA110Accident · Minor injuriesLimited investigationFinal reportAeronca O58B · Bremerton, WADuring cruise, eng lost power. Plt attempted to restore power with no success; eng power was surging but less than enough to sustain flight. Forced landing was executed into rough terrain. Inspection revealed fuel selector deteriorated by age and use. The…Jun 15, 1988 · N49203 · Substantial damageNTSB MIA88FA192Accident · Serious injuriesField investigationFinal reportBell 47G3B-1 · Benoit, MSThe plt said the engine misfired three times during takeoff and lost partial power. The helicopter settled into a rice field and the damaged spray booms became entangled. The helicopter nosed over in the high vegetation. The plt stated the engine accelerated…Jun 15, 1988 · N73947 · Substantial damageNTSB LAX88LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Show Low, AZThe plt attempted to takeoff in his conventional gear acft using rwy 21. The local wind was estimated at 180 degrees, 15 knots with gusts to 35 knots. The plt stated that immediately after rotating for takeoff 'a gust of wind caught us & threw us…Jun 15, 1988 · N2509K · Substantial damageNTSB DEN88LA130Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · West Jordon, UTJun 15, 1988 · N70471 · Substantial damageNTSB NYC88LA165Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Wantagh, NYThe pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two…Jun 14, 1988 · N6110V · Substantial damageNTSB MKC88LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Dighton, KSDuring an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field…Jun 14, 1988 · N731CD · Substantial damageNTSB MIA88FA191Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe 25 yr old student plt was practicing take-offs & ldgs on rwy 11L in preparation for his pvt plt flt test. When he departed, about 1.9 hrs prior to the accident, the winds were 090 degs at 13 knts. At the time of the accident the winds had increased to 18…Jun 14, 1988 · N2387T · Substantial damageNTSB LAX88LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZWhile flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the…Jun 14, 1988 · N49792 · Substantial damageNTSB DEN88LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rifle, COThe student plt was flying a x-country training flt. The flt was not on the planned route. The plt flew into a box canyon too narrow to complete a turn and could not climb fast enough to clear the terrain at the end of the canyon. The pilot attempted a turn…Jun 14, 1988 · N2262E · Substantial damageNTSB DEN88LA127Accident · No injuriesLimited investigationFinal reportCessna 182K · Cotton City, NMThe pilot reported that he was attempting to start the Cessna 182 for a cross country, solo, personal transportation flight. During the starting procedures, the engine backfired and the pilot smelled and saw smoke coming from the engine cowling area. The…Jun 14, 1988 · N2829R · DestroyedNTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…Jun 14, 1988 · N7776F · DestroyedNTSB SEA88IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Seattle, WAAfter the main gear touched down, thrust levers were placed in the idle reverse position. Once the aircraft's nose gear contacted the runway, braking and full reverse thrust was applied. The aircraft started to drift to the left of the runway centerline. The…Jun 13, 1988 · N308AS · Minor damageNTSB MIA88LA190Accident · No injuriesLimited investigationFinal reportCessna 150J · Carthage, MSWhile on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a…Jun 13, 1988 · N50945 · Substantial damageNTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.Jun 13, 1988 · N7628Q · Substantial damageNTSB FTW88LA137Accident · No injuriesLimited investigationFinal reportCessna 182D · Gilmer, TXThe pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and…Jun 13, 1988 · N9087X · Substantial damageNTSB FTW88LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mounds, OKThe instructor was demonstrating an engine out emergency to the student. The engine balked on the attempted go-around and he completed the landing. Thereafter, his first two takeoff attempts were aborted because of insufficient distance to complete the…Jun 13, 1988 · N94370 · Substantial damageNTSB DEN88LA165Accident · No injuriesLimited investigationFinal reportHall HP-18 · Westcliffe, COThe plt said his glider was being towed for takeoff from a dry, dusty, grass strip. He said the tow plane blew up the dust and he was unable to see to maintain alignment with the 75 ft wide strip. There was a drop off on the lt side of the strip and tall…Jun 13, 1988 · N81940 · Substantial damageNTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…Jun 12, 1988 · N1453A · Substantial damageNTSB LAX88LA222Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Palm Springs, CAPilot misjudged the altitude of the mountain peak.Jun 12, 1988 · N43310 · DestroyedNTSB LAX88LA221Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Fremont, CADuring a local flt, the glider encountered a windshear and lost altitude. The pilot was unable to regain the lost altitude and a forced landing was made where during the landing roll the glider collided with rough terrain.Jun 12, 1988 · N103BK · Substantial damageNTSB LAX88DVD05Accident · No injuriesFinal reportKerlin Avid Flyer · Tracy, CADuring a local high speed taxi test, the airplane became airborne. Shortly after takeoff the engine quit. The airplane was landed straight ahead in an open field. During the landing roll, the airplane nosed over. The pilot did not report any mechanical…Jun 12, 1988 · N4642S · Substantial damageNTSB FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…Jun 12, 1988 · N666BK · Substantial damageNTSB ATL88LA193Accident · No injuriesLimited investigationFinal reportCessna 195A · Port Clinton, OHDuring touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at…Jun 12, 1988 · N1527D · Substantial damageNTSB NYC88LA164Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Marlboro, NJThe pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a…Jun 11, 1988 · N2313 · Substantial damageNTSB NYC88LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lehighton, PAThe student pilot, on his third solo, experienced a loss of directional control during a go-around and settled into low trees and brush on the south side of the runway. The pilot reported the winds as calm. He stated that the left main wheel went off the left…Jun 11, 1988 · N44699 · DestroyedNTSB DEN88DTM02Accident · No injuriesFinal reportEagle DW-1 · Enterprise, UTThe plt reported that he had been going under a powerline that ran across the fld being treated. On the acdt pass he lost sight of the powerline and pulled up into the line. The visibility was unrestricted and the pass was being made north to south at mid…Jun 11, 1988 · N8807E · DestroyedNTSB BFO88FA054Accident · Serious injuriesField investigationFinal reportCessna 177RG · Clinton, MDEng pwr loss occurred when the instrument student advanced the throttle to do a go-around when the acft was too high to lnd on rwy 5 following a simulated instrmt apch. The instr took control of the acft and about half-way down the rwy, at about 300 ft AGL,…Jun 11, 1988 · N2070Q · Substantial damageNTSB ANC88LA152Accident · 1 fatalLimited investigationFinal reportChampion 7AC · Coldfoot, AKUndetermined.Jun 11, 1988 · N81725 · DestroyedNTSB NYC88LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Robbinsville, NJThe acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3…Jun 10, 1988 · N97954 · Substantial damageNTSB LAX88LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Redding, CADuring a solo instructional flt, the pilot stated that he may have had his foot on the left rudder pedal on landing. When the airplane touched down it veered to the left off the runway and into a ditch. There were no reported mechanical failures or…Jun 10, 1988 · N25409 · Substantial damageNTSB LAX88DUG04Accident · Serious injuriesFinal reportBushby Mustang II · Upland, CADuring a pleasure flight, while flying s turns and lazy eights, the canopy suddenly separated from the airplane. The airplane was landed without further incident. The canopy was not recovered. The reason for the separation was not determined.Jun 10, 1988 · N1AZ · Minor damageNTSB FTW88FA119Accident · 4 fatalField investigationFinal reportCessna 205 · Elgin, TXThe pilot radioed that he was running out of fuel while being vectored for landing. The ceiling was about 900 feet with 5 miles visibility and the accident occurred in a level grass field. Witnesses heard the engine cutting out and a loss of control occurred…Jun 10, 1988 · N8181Z · DestroyedNTSB DEN88FA126Accident · Serious injuriesField investigationFinal reportCessna 404 · Denver, COThe plt was on a flt from greeley to Denver, Colorado to obtain minor maint on a cargo door. As the acft was being vectored on final apch, the plt rprtd that he believed the acft had fuel starvation. Subsequently, the acft was observedto make a complete roll…Jun 10, 1988 · N8827K · Substantial damageNTSB CHI88DEM06Accident · No injuriesFinal reportKoopsen Miller Sport II · Lake City, MIJust prior to turning on final approach to land, the pilot experienced a complete loss of power. He continued the approach but decelerated more rapidly than he anticipated and was unable to clear a stand of trees on the approach path. Examination revealed a…Jun 10, 1988 · N5574A · Substantial damageNTSB ATL88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccormick, SCThe student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to…Jun 10, 1988 · N2609G · Substantial damageNTSB ANC88FA067Accident · 1 fatalField investigationFinal reportDe Havilland DHC-2 · Chugiak, AKThe pilot-in-command, a certified mechanic, performed his own maintenance on the acft. This maintenance required the removal, reinstallation & rigging of the ailerons. As the plt was taking off on the 1st flt after maintenance, the acft entered a roll after…Jun 10, 1988 · N48108 · Substantial damageNTSB MIA88LA188Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Tampa, FLThe plt stated that on final apch to Tampa international airport, he reduced power, put the gear down and, as he tried to add power, none was available. During an attempted forced landing, he hit the top of an office trailer and a guy wire before coming to…Jun 9, 1988 · N6390U · Substantial damageNTSB LAX88DVA06Accident · Minor injuriesFinal reportCraven Teenie TWO · Fowler, CADuring cruise flight, the pilot reported a loss of oil pressure. The engine then sputtered and quit. The pilot initiated a forced landing where the airplane collided with several wooden crates short of the intended ldg area. Inspection of the engine revealed…Jun 9, 1988 · N6052 · DestroyedNTSB FTW88LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roanoke, TXThe pilot lost directional control while attempting a takeoff. The airplane ran off the right side of the runway and struck a wind tetrahedron, a fence, and a low concrete wall. The plt did not submit an acc report.Jun 9, 1988 · N84889 · Substantial damageNTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.Jun 9, 1988 · N1103F · Substantial damageNTSB CHI88LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairmont, MNThe student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…Jun 9, 1988 · N5317K · Substantial damageNTSB ATL88FA191Accident · 1 fatalField investigationFinal reportCessna 421B · Knoxville, TNJun 9, 1988 · N700SC · DestroyedNTSB SEA88LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Wenatchee, WAAirframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had…Jun 8, 1988 · N7243X · Substantial damageNTSB LAX88LA218Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayward, CAAt the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…Jun 8, 1988 · N47TT · Substantial damageNTSB LAX88LA217Accident · 1 fatalLimited investigationFinal reportCessna 150F · Quartzsite, AZJun 8, 1988 · N7892F · Substantial damageNTSB FTW88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Cleveland, TXThis acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…Jun 8, 1988 · N7317T · Substantial damageNTSB FTW88LA116Accident · No injuriesLimited investigationFinal reportCessna 182L · Angola, LAThe pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in…Jun 8, 1988 · N3153R · Substantial damageNTSB CHI88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Marion, INThe pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover…Jun 8, 1988 · N3737P · Substantial damageNTSB CHI88LA130Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bedford, INThe pilot landed beyond his intended touchdown point on the runway due to excessive airspeed during the approach to landing and touchdown. When the aircraft ran off the departure end of the runway the pilot elected to perform an intentional ground loop/swerve…Jun 8, 1988 · N7151P · Substantial damageNTSB ATL88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · East Liverpool, OHThe student pilot reported that he flared late during ldg. The airplane ballooned and started drifting to the right. The student added pwr and left rudder in an attempt to maintain control; he 'overcompensated' with left rudder input, and lost directional…Jun 8, 1988 · N89059 · Substantial damage