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 ATL88LA237Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, ALThe plt reported that he landed on a grass strip adjacent to the paved rwy, to 'save the (airplane) tires' from excessive wear. He stated that the airplane groundlooped during the rollout when it encountered a hole in the turf. A mechanic who examined the…NTSB ANC88LA116Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Hartman River, AKThe pilot had just taken off from a sand bar. During climb-out on the downwind leg, he felt the engine was not producing the proper power because the airspeed was dropping and the climb had stopped. He made a left turn and crash landed on the sand bar to…NTSB SEA88LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the…NTSB SEA88LA161Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Shelton, WAThe pilot reported a complete loss of power in cruise flight while ferrying an aircraft to its home base after an annual inspection. The pilot landed in a small field of rye crop. The pilot stated that the size of the field precluded a normal approach. The…NTSB LAX88IA311Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · San Francisco, CADuring cruise flight, approximately one hour after departure, the captain complained of possible indigestion. A few hours later, the captain complained of tingling in his fingers and numbness in his shoulder. Another captain was on board and was asked to sit…NTSB CHI88FA218Accident · 2 fatalField investigationFinal reportCessna 150F · Bellbrook, OHFailure of the PIC to maintain sufficient airspeed to sustain flight during initial climb to clear a barrier after taking off from an off airport area.NTSB ATL88LA236Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bamberg, SCWhile at cruise, the pilot reported hearing a ticking sound coming from the engine. Shortly afterward the eng quit. During the emergency landing, the airplane nosed over. Engine examination disclosed that teeth from the crankshaft and camshaft gears were…NTSB ATL88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rock Hill, SCThe plt reported that the engine began to run rough & lose pwr while he was circling some property he owned. He subsequently attempted to land at a nearby ultralight airstrip. He stated that he didn't remember anything after that. The airstrip owner reported…NTSB MKC88LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Elaine, ARDuring an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine…NTSB LAX88FA294Accident · Serious injuriesField investigationFinal reportBeech A36TC · Paradise, CAAn undetermined loss of engine power and the pilot in command's apprehension in undertaking the appropriate emergency actions to attempt an aerial restart. Contributing to this accident was the pilot's lack of experience and inadequate training.NTSB LAX88DVA11Accident · 1 fatalFinal reportTedford VARI-EZE · Mariposa, CAAcft observed to dive into grnd. Investigation revealed inflt breakup and separation of canards. Exam of canards revealed modification to increase chord improperly done, adding excess weight aft of CG and making components subject to flutter. One mounting…NTSB ATL88LA234Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Ridgeland, SCThe pilot experienced a complete power loss about four hours after departing pompano beach. The pilot had varied his altitude throughout the flight. The flight manual indicates that the acft could fly about 3.8 hours, at 2500 feet altitude, on 48 gallons of…NTSB ATL88DMG08Accident · No injuriesFinal reportPiper PA-25-235 · La Grange, NCThe pilot reported that the spray boom collided with a tree, resulting in the left aileron being jammed in an uncontrollable position. The acft impacted in a field.NTSB ATL88DLT02Accident · No injuriesFinal reportGrumman G-164B · Dancyville, TNNTSB ANC88DAG07Accident · No injuriesFinal reportCessna T182RG · Kenai, AKThe pilot was taxiing the Cessna to the ramp area when the airplane wing struck a light pole near the terminal building. The pilot stated that he did not see the light pole before impact and that it blended in with the natural surroundings.NTSB NYC88LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYThe plt reported to the local police that he was having trouble getting lift and was attempting an off airport landing when the acft stalled at low alt and crashed. The pilot did not file an accident report.NTSB NYC88LA226Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJThe CFI was demonstrating a departure autorotation to a prospective student. A high rate of descent with low airspeed and low rotor RPM developed and the CFI attempted a power recovery with no results. The acft touched down hard, the skids collapsed and the…NTSB NYC88LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Readington, NJWhile attempting a go-around from a rejected landing in x-wind conditions the plt who had no landings in the last 90 days failed to initiate the go-around with sufficient time/distance to clear trees off the end of the rnwy. The acft struck the trees and was…NTSB NYC88LA224Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Wall Township, NJIncapacitation of the pilot due to a heart attack and an emergency landing in trees by a non-pilot passenger.NTSB NYC88LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Freeport, PAThe plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the…NTSB NYC88DHA03Accident · No injuriesFinal reportDebarry/Starduster SA100 · Slatington, PAAs the homebuilt acft was climbing thru about 300 ft AGL during initial climb after takeoff, the eng lost power. The plt was able to restart the eng (once), but as he turned the acft back toward the arpt, the eng lost power again. During an emerg landing, the…NTSB LAX88LA293Accident · Minor injuriesLimited investigationFinal reportAeronca 0-58B · Grass Valley, CAWhile enroute, the engine sputtered then quit. The pilot initiated a forced landing to a plateau directly below. While on final approach the airplane flew through a downdraft. The pilot was unable to land the airplane on the plateau, instead it collided with…NTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…NTSB FTW88LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 65-TL · Texarkana, TXThe airport operator stated he saw the airplane turn in to land. He said it appeared to stall and then make a quick turn to the left, into a tree.NTSB FTW88DPJ10Accident · No injuriesFinal reportCessna A188B · Holdenville, OKThe aircraft was in cruise flight at 500 ft AGL when a total loss of power occurred. The pilot jettisoned the load and executed an emergency descent to land at the nearest available clearing. The aircraft collided with the terrain with high rate of descent…NTSB CHI88LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Elkhart, INWhile enroute on the second leg of a solo student cross country, the aircraft experienced a total loss of engine power due to fuel exhaustion. The student pilot executed a forced landing in a bean field and the aircraft nosed over during the landing roll,…NTSB CHI88LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Kelley'S Island, OHShortly after crossing the runway threshold on final approach, the pilot experienced a wind shift and elected to attempt a go-around. The pilot discontinued the attempted go-around when he judged that he would be unable to clear trees located at the departure…NTSB CHI88LA215Accident · No injuriesLimited investigationFinal reportCessna 170 · Boyceville, WIShortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft…NTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILNTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…NTSB BFO88LA074Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Gaithersburg, MDThe pilot reported that the local winds were varying from 340 degrees to 360 degrees at 12 knots gusting to 20 knots. The pilot stated that he lost directional control due to gusty winds while on landing roll. The aircraft contacted a VASI light and then a…NTSB ATL88FA233Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Pittsboro, NCThe plt had an instrument plt accompany him on the flight to myrtle beach in the event the wx required IFR for the return flt. When they arrived at myrtle beach, the plt decided that they would remain overnight. After visiting some night spots and doing some…NTSB SEA88LA159Accident · No injuriesLimited investigationFinal reportCessna 150D · Athol, IDAcft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over.NTSB SEA88LA158Accident · No injuriesLimited investigationFinal reportCessna 185 · Hillsboro, ORThe pilot reported that the engine lost power during a fuel tank switchover. The aircraft collided with a telephone pole guy wire on the road during the forced landing. The investigation revealed a fuel leak induced when the fuel boost pump was in operation.…NTSB SEA88LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Tyge Valley, ORThe pilot reported that late in the apch, the acft developed a high sink rate. However, he used elevator only to correct the sink rate. The aircraft impacted the runway and bounced. On the third bounce, the nose gear failed and the aircraft nosed over. The…NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB LAX88IA295Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-51 · Honolulu, HIThe aircrafts encounter with the engine exhaust flow and related turbulence from a heavy Boeing 747, which crossed the approach end of the runway about 1 minute and ten seconds prior to the incident.NTSB LAX88DVA12Accident · No injuriesFinal reportAyres S2R · Kerman, CADrg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire.NTSB FTW88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Ada, OKAfter a loss of engine power, the airplane landed in a soft, plowed field, 50 feet short of a runway at the destination airport. After touchdown, it nosed over to the inverted position. According to the operator, the pilot said he might have run out of fuel.…NTSB FTW88DRD19Accident · No injuriesFinal reportSchweizer G-164B · Catahoula, LAThe ag airplane was being utilized to scare birds away from the rice fields. It was 15 feet AGL when the engine backfired and quit. The airplane collided with the terrain and burned. The engine and engine accessories were so destroyed by fire that nothing…NTSB ATL88LA232Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Paducah, KYAfter departure the eng quit & PIC made an autorotative landing in a wooded area. Initial exam of eng revealed water in the carb float bowl. Investigation showed helo had 100 hr inspection recorded in the log, but may have been returned to service by mechanic…NTSB ANC88LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dillingham, AKThe pilot-in-command was beginning his descent for landing at Dillingham, Alaska and did not apply carburetor heat until his engine began to sputter. The engine stopped producing power and the pilot was unable to restart the engine. He landed on the tundra…NTSB NYC88LA222Accident · No injuriesLimited investigationFinal reportCessna 152 II · Coatesville, PAThe student plt was returning to the airport following a 1 hr local flight. He stated that the engine sputtered and lost power. The plt selected a field for a forced landing and approached it from west to east. The plane struck a road short of the field and…NTSB MKC88LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hebron, NEWhile making a aerial application swath run, the pilot was checking his spray booms because of some malfunctioning nozzles. Exiting the field between two groups of trees on the border he failed to see power line poles. He struck the wires, then the terrain,…NTSB MIA88LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300E · San Juan, PRWhile on a business flt shortly after departure while climbing to cruise, the plt reported that the eng quit. The acft was ditched & has not been recovered therefore no determination could be made as to the reason for the reported loss of eng power. The plt…NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…NTSB MIA88FA260Accident · 6 fatalField investigationFinal reportPartenavia P-68C · Duncan Town, BahamasThe acft crashed in the ocean nr Duncan Town, Bahamas. The wx according to witnesses was VMC. The flt had been airborne enroute from nassau for about 1 hr and 20 minutes. Witnesses on a nearby boat said the acft was flying in a slight left bank when the left…NTSB MIA88FA257Accident · Serious injuriesField investigationFinal reportHughes 500 · Riviera Beach, FLThe traffic watch helicopter was cruising northbound along the interstate at 450 ft AGL & 85 KTS airspeed. A grinding noise was heard & the tail rotor separated from the acft. The acft began an uncommanded right turn which was arrested in about 1/4 turn. The…NTSB LAX88LA290Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Paula, CADuring a cross country flight, the pilot diverted to a closer airport due to a low fuel state. The pilot was unable to land the airplane on the first attempt. During the second attempt, the engine quit. The pilot made an emergency landing where during the…NTSB LAX88DUQ04Accident · No injuriesFinal reportTexas Helicopter M74A · Lancaster, CADuring an aerial application flight, just after takeoff, the nose of the helicopter suddenly pitched up. The pilot reduced power to keep from climbing. The fore/aft cyclic control had no effect. The helicopter settled to the ground resulting in substantial…