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 CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…NTSB BFO88FIG01Accident · Minor injuriesFinal reportCessna 152 · Annapolis, MDThe stu & instr were returning to mitchellville after doing several touch & go landings at stevensville. The acft was level at 1700 ft when a power loss occurred. Attempts to restart the engine were unsuccessful. The instr took control of the acft and landed…NTSB ATL89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140 · MissingThe airplane and pilot reportedly departed moncks corner, SC sometime between 1900 and 2000 EDT on 4/17/88. The airplane was subsequently reported Missing, and search efforts were conducted between 4/20/88 and 4/29/88. Aircraft damage and injury index are…NTSB ATL88LA148Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lowell, OHThe plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to…NTSB ATL88IA147Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHNTSB ANC88LA044Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Talkeetna, AKThe pilot stated that during the takeoff run on the frozen field the aircraft struck a snow berm causing the aircraft to ground loop.NTSB ANC88LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot stated that he made a hard landing and at that time he lost directional control of the aircraft. The plt stated that the acft bounced and when he tried to correct the bounce the acft yawed left. The rt main gear collapsed and the acft groundlooped.NTSB ANC88FA045Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot-in-command was a certificated airframe and powerplant mechanic who was working on the airplane. The owner stated that the mechanic was not authorized to fly the airplane. The pilot's brother stated he had just disembarked from the airplane after a…NTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…NTSB SEA88FA078Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Port Angeles, WADrg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…NTSB NYC88LA126Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Windham, CTThe pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the…NTSB MKC88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Red Cloud, NEAfter a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the…NTSB MKC88LA077Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Belton, MOWhile practicing touch and go landings, PIC said the engine quit shortly after takeoff. An emergency ldg was made in a nearby field, and during the roll out, the acft struck a terrace and nosed over. Post flight inspection revealed acft fuel tanks were empty.NTSB MIA88WA161Accident · Serious injuriesForeign investigationBoeing 757-225 · San Jose, Costa RicaNTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.NTSB MIA88LA152Accident · No injuriesLimited investigationFinal reportDenney Kitfox · Lakeland, FLThe plt stated that he was flying in the homebuilt acft area at the 'sun and fun fly in' when the engine quit. An attempt was made to land in a field, which he couldn't make, and came to rest in some scrub trees. The plt also stated that he had been having…NTSB MIA88LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe plt stated that he was enroute to sanford, FL when the engine lost power. He then landed on I-4, striking a van with the left wing and propeller. The operator stated that prior to removing the wings in order to transport the acft back to sanford, all the…NTSB LAX88FA162Accident · 2 fatalField investigationFinal reportCessna 210L · Maricopa, CAAircraft inadvertent flight into instrument meteorological conditions.NTSB LAX88FA161Accident · 4 fatalField investigationFinal reportCessna 172G · Los Banos, CAFailure of the pilot to maintain control of his aircraft to avert a collision with the ground.NTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…NTSB DCA88MA052Accident · Serious injuriesMajor investigationFinal reportde Havilland DHC-8 · Seattle, WAShortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…NTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…NTSB ATL88LA145Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barnwell, SCDuring initial climb after takeoff right side of the engine cowling unfastened and began fluttering violently. The instructor assumed control of acft & made a forced landing straight ahead into a cultivated field. The acft nosed up sustaining substantial…NTSB MIA88LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Monticello, FLThe plt stated that while enroute to st. petersburg, and in the vicinity of montecello FL, he began to experience severe engine vibrations and a loss of power. He then selected a field to land in & on his apch, the acft struck some trees, sheared off the…NTSB MIA88LA148Accident · Serious injuriesLimited investigationFinal reportHenderson RV-4 · Defuniak Sprngs, FLShortly after takeoff at an alt of aprx 100 ft while on a personal flt, the eng quit. The plt banked the acft to the left to land on a rd but lost control during the maneuver. The acft descended uncontrolled and collided with terrain. Examination of the…NTSB MIA88IA150Incident · No injuriesIncident investigationFinal reportBeech 58 · Jacksonville, FLThe plt stated that while on landing rollout, the gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed evidence that would suggest that the gear was up and locked at the time the acft landed.NTSB LAX88WA165Accident · 1 fatalForeign investigationPiper PA28 · Mulege, MexicoNTSB DEN88FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Deer Lodge, MTNTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…NTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…NTSB MKC88LA076Accident · No injuriesLimited investigationFinal reportCessna 182E · Clarksville, ARWhile attempting to land at night on a radio activated runway lighted airport, PIC was unable to activate the system. After several attempts to activate the runway lights, he elected to land on the unlighted runway. He aligned about 20 yards right of…NTSB MIA88LA147Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hastings, FLWhile on an aerial application flt shortly after takeoff, the eng lost power. The plt then dumped the load of fertilizer & landed the acft in a field. After touchdown it nosed over & came to rest. Examination of the eng revealed that the no. four cylinder…NTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…NTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…NTSB DCA88WA050Incident · No injuriesForeign investigationBoeing 747 · Schiphol-Amster, NetherlandsNTSB BFO88FA036Accident · Minor injuriesField investigationFinal reportFokker F28 MK 4000 · Charleston, WVEngine and airframe failure were caused by the the separation of the first stage low pressure turbine disk. The disc interstage seal was installed inadequately, resulting in rubbing between the seal and disk, causing failure of the disk. Inadequate procedure…NTSB ATL88LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Painesville, OHThe CFI reported that while performing a simulated short field take-off the acft encountered a downdraft and settled into the trees. The CFI held his certificate for one month and the student plt had logged just over fifty hours. This airport was not approved…NTSB ATL88FA142Accident · Serious injuriesField investigationFinal reportBalloon Works AX-8B · Alpharetta, GANTSB ANC88IA047Incident · No injuriesIncident investigationFinal reportCessna 207A · Takslesuk Lake, AKThe scheduled commuter flight, friendship flight 305, was en route from chevak, Alaska to bethel, Alaska. During cruise flight, the airplane experienced an engine failure resulting a a forced landing on rough, snow covered terrain. The pilot-in-command stated…NTSB SEA88IA074Incident · No injuriesIncident investigationFinal reportBoeing 727-290 · Portland, ORThe Boeing 727 was pushed back fm the gate counterclockwise through an arc of 90 degrees resulting in mispositioning the acft relative to the intended taxi direction. The ground crew (tug and safety operators) attempted to resolve the out of position…NTSB MIA88LA146Accident · Minor injuriesLimited investigationFinal reportFischer STAR-LITE · Lakeland, FLThe owner/manufacturer of the homebuilt acft repaired the horizontal stabilizers, then asked the designer to test fly the aircraft. After takeoff, at an alt of aprx 7,000 feet MSL, in a nose low attitude, at 158 mph ( 28 mph greater than vne) both horizontal…NTSB MIA88FA144Accident · Serious injuriesField investigationFinal reportBeech A-23 · Fort Myers, FLThe private pilot experienced an engine failure on final approach and executed a forced landing to a wooded area and crashed. The pilot said he had flown about 2.0 hours on the right tank and did not switch to the left tank prior to landing. Another pilot had…NTSB LAX88LA166Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mayer, AZNTSB LAX88LA160Accident · No injuriesLimited investigationFinal reportBell 47D1 · Taft, CANTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.NTSB FTW88IA090Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Wichita Falls, TXThe right engine upper cowling separated during initial climb, went rearward, and shattered a window at the right rearmost passenger seat which was not occupied. The pilot secured the engine and made an uneventful landing. The cowling separated due to…NTSB ATL88LA215Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Lawrenceville, GAThe instructor reported that he initiated a sim engine failure during climb at about 100 ft AGL, as part of the recurrency flight. The pilot initiated an autorotation, at about 50 ft AGL, the rate of descent increased and the throttle was rolled in to arrest…NTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…NTSB SEA88LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Mead, NVThe pilot was flying very close to the water for the purpose of dropping beer to friends. The pilot allowed the aircraft to inadvertently descend and strike the water.NTSB SEA88LA073Accident · No injuriesLimited investigationFinal reportHughes 269C · Sitka, AKDuring sling operations, the long line became separated and entangled in the tail rotor at about 300 feet AGL. The pilot landed the helicopter onto a beach area where it rolled over onto its left side striking the main rotor. No accident report has been filed…