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 DEN88LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Great Falls, MTThe private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot…NTSB ANC88FA051Accident · 2 fatalField investigationFinal reportBeech C55 · Tyonek, AKThe two pilots were operating the aircraft under the authority of a ferry permit which allowed flt only during day VFR conditions and with a single pilot. They requested and received just the weather at the destination airport, which was VMC. En route the flt…NTSB ATL88LA157Accident · No injuriesLimited investigationFinal reportCessna 180A · Danville, KYThe plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle…NTSB ATL88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, OHThe plt reported that the engine began to run rough about 2 hrs & 45 minutes into the low-level aerial photo flt. The engine subsequently lost power altogether and the plt made a forced ldg in a marsh. The airplane nosed over during the ldg. Post-crash exam…NTSB SEA88FA084Accident · 1 fatalField investigationFinal reportMaule M5-210C · Bend, ORPlt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective…NTSB NYC88LA130Accident · No injuriesLimited investigationFinal reportBeech 35 · New Haven, CTDuring engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control…NTSB MKC88LA079Accident · No injuriesLimited investigationFinal reportCessna 310P · Berryville, ARWhile trying out his friend's newly purchased twin, the pilot stated an emergency landing was made due to power loss because of fuel starvation. The PIC said he was negligent because he did not possess a multiengine rating and also did not study the fuel…NTSB MIA88LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hialeah, FLEngine stalled during landing roll. During attempts to restart engine pilot flooded it. The engine backfired and the excess fuel in the carburetor caught fire. The pilot did not motor the engine in time to draw the flames into the engine and the fire spread…NTSB FTW88LA093Accident · No injuriesLimited investigationFinal reportPezetel PZL-M-18 · Cheneyville, LAThe pilot said that after takeoff the aircrft seemed extremely tail-heavy and that he used 'both feet and one arm' to hold forward stick. He said the aircraft was almost uncontrollable in pitch and displayed a right turning tendendcy. The pilot returned to…NTSB DEN88DTE03Accident · No injuriesFinal reportPiper PA-25-235 · Akron, COThe pilot said the wind was from 200 degrees at 10 KTS, as he began his takeoff on runway 13. When the aircraft reached 20-30 feet AGL it began to sink and collided with the ground. The pilot said he thought he encountered a wind shear or change of wind…NTSB DCA88WA057Incident · No injuriesForeign investigationMaule M4 · Watson Lake, CanadaNTSB CHI88DEX04Accident · No injuriesFinal reportCessna 172M · Alexandria, INAircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…NTSB ATL88FA155Accident · Serious injuriesField investigationFinal reportCessna 150L · Knoxville, TNNTSB ANC88LA050Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot returned to Fairbanks int'l airport from an intended cross-country flight due to deteriorating weather. During the flight the airplane felt out of trim, and she elected to land on the longest runway available (10,300). During the landing roll she…NTSB MIA88LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Kissimmee, FLWhile landing on runway 24 in strong gusty crosswind conditions the student plt lost control of the aircraft. While making a go-around the aircraft drifted to the left side of the runway striking the VASI lights. The aircraft then continued on to the left…NTSB BFO88DIG02Accident · 1 fatalFinal reportLamb Shoestring S-102 · Gaithersburg, MDThe pilot inproperly performing aerobatics without sufficient altitude to complete a recovery.NTSB ATL88LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Watkinsville, GAStrong headwinds were encountered during the x-c flt. The plt landed at an arpt to refuel but found the arpt FBO to be closed. He continued on toward his destination. About 10 miles from his destination, he made a precautionary ldg in a field due to a…NTSB SEA88FA083Accident · 1 fatalField investigationFinal reportCessna 310G · Las Vegas, NVDuring initial climb at 100 ft after takeoff, the pilot announced he had lost an engine. Witnesses observed the aircraft enter a nose high attitude, roll to the right and descend in a vertical nose down attitude until impact with the ground. The aircraft…NTSB LAX88DUA01Accident · 2 fatalFinal reportHernandez Thorp T-18 · Palos Verdes, CAThe pilot was demonstrating the acft for the passenger for a possible sale. They were part of a flight of two over the pacific ocean. The owner of the aircraft being demonstrated was in the second aircraft. The pilot of the demo acft radioed to the second…NTSB ANC88LA049Accident · No injuriesLimited investigationFinal reportCessna 337D · Kenai, AKThe private pilot was practicing simulated instrument flight with his flight instructor in their mutually-owned airplane, when both engines quit within minutes of each other due to fuel exhaustion. The airplane struck trees in the ensuing emergency descent…NTSB ATL88LA153Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Memphis, TNThe pilot reported that the engine lost pwr in-flt due to fuel exhaustion. A forced ldg was made in a plowed field. The airplane nosed over during the ldg. The plt noted after the accident that he should have topped off the fuel tanks prior to departure. The…NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…NTSB ATL88LA151Accident · Serious injuriesLimited investigationFinal reportCirrus Design Standard · Chester, SCThe glider pilot failed to maintain sufficient altitude while on final approach for landing and struck trees.NTSB ATL88LA149Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Chester, SCWhile thermaling during the sailplane competition, N45BD was slightly higher and to the left of N295SZ. N45BD made a right turn and struck the right inboard wing section of N294SZ with the outboard wing tip of N45BD. The outboard wing tip of N45BD separated…NTSB ATL88IA146Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101/102 · Dothan, ALDuring cruise flight at 12,000 ft, the flight crew of the DHC-8 observed a low oil pressure warning light. About five seconds later, the right engine fire warning light illuminated. Fire was confirmed and the extinguisher discharged. The fire was extinguished…NTSB ATL88FA150Accident · Minor injuriesField investigationFinal reportCessna 152 · Moncks Corner, SCNTSB MIA88LA158Accident · No injuriesLimited investigationFinal reportBeech E55 · Pahokee, FLWhile on an instructional flt practicing short & soft field landings, the acft was landed gear up. The instructor plt stated there was no failure or malfunction of the landing gear warning horn and that when the throttle was retarded fully the horn sounded.NTSB MIA88LA156Accident · 1 fatalLimited investigationFinal reportMooney M-20J · Perry, FLJacksonville center reported a loss of radar contact with the acft at approx 2133 EDT after it descended from its last assigned altitude of 6000 feet. The sole occupant and debris from the acft were found shortly thereafter. The results of an autopsy on the…NTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…NTSB DCA88WA055Accident · 2 fatalForeign investigationMcdonnell Douglas DC-3 · Mozambique-Sa, MozambiqueNTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…NTSB NYC88LA115Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Walton, NYThe pilot decided to land on a sod strip. He bounced once, then lowered the nose to keep it on the ground. The prop dug into the ground and the aircraft flipped over. The pilot reported that he was practicing manuevers and wanted to practice a sod landing.NTSB MIA88LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Deland, FLAfter landing at umatilla, muni, an unattended arpt, the plt asked an unauthorized individual to fill the acft's tanks. The individual stated that fuel is not sold to transient acft. The plt departed with the fuel tank gauges indicating 1/4 each. When it was…NTSB LAX88LA167Accident · No injuriesLimited investigationFinal reportCessna 182D · Coolidge, AZAt the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…NTSB DEN88FA099Accident · 2 fatalField investigationFinal reportBeech A23-19 · Gunnison, COOn a cross country flt, the plt attempted to climb through a pass which was above the effective service ceiling of the acft. At approximately the effective service ceiling of the acft the acft collided with terrain. The acft was destroyed by impact and post…NTSB SEA88LA081Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Grace, IDPlt/owner not certificated for aerial application. No record found of prior experience in aerial application. Replaced certificated plt for undet reason. Witnesses observed acft enter stall/spin during first aerial application turnaround maneuver in strong…NTSB FTW88LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Azle, TXThe operator stated the night instrument training flight departed with 8.5 gallons of fuel. One hour and thirty minutes later, the airplane hit a tree during flare for a forced landing due to engine failure. The student stated the fuel gage indicated one…NTSB FTW88IA092Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Henderson, TXThe pilot experienced total loss of power from the left engine and a partial loss of power from the right engine due to fuel starvation. The main fuel tanks on which the engines were operating were found empty but there was an adequate fuel supply in the…NTSB FTW88DRA09Accident · 1 fatalFinal reportCurtis Baby Great Lakes · Angleton, TXShortly after liftoff, the acft was observed to enter a rt bank and then a left bank to a course parallel to the t/o rwy. It was subsequently observed to enter a left turn which steepened and the acft nosed over until ground impact. Original turn was executed…NTSB ANC88LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Cantwell, AKThe air-taxi pilot stated that he attempted to takeoff from a private, dirt runway that was dry in the middle and muddy towards the edges. During the takeoff roll, the airplane's left main gear tire encountered the soft, muddy area and turned abruptly towards…NTSB MIA88LA155Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mcdavid, FLThe plt stated that the flt was 15 miles from the destination & had been diverted due to haze. While flying at an alt of aprox 2,000 ft, the eng quit due to non-mechanical reasons. He was unable to restart it. The plt landed the a/c on a road, during which…NTSB MIA88LA154Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Orlando, FLThe plt stated that the winds started to pick up & he decided to land. During the apch just before touchdown, the gondola struck a tree, causing the occupants to fall against each other, breaking one of the passengers legs.NTSB CHI88DEC01Accident · Minor injuriesFinal reportBeech 23 · Brighton, MIThe unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…NTSB ANC88LA046Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Near Central, AKThe pilot-in-command landed at the 'hot' refueling site and was attempting to exit the helicopter for a crew change. The hot refueling landing pad consisted of a black membrane with bundles of laths placed perpendicular to the helicopter's skids to prevent…NTSB NYC88LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lincoln Park, NJDuring takeoff the aircraft was observed to become briefly airborne; then the wing dipped just before ground contact. The aircraft crashed about 50 feet from the departure end of the runway and about 300 feet to the right. The pilot said he experienced a…NTSB NYC88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Slatington, PAThe pilot landed at Slatington, Pennsylvania during strong wind conditions. When the pilot applied brakes, a sudden gust of wind lifted the left wing and pushed the aircraft off the right side of the runway down an embankment, and into a tree stump.NTSB MIA88LA204Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLWhile en route, on a personal cross country flt, the alternator belt broke resulting in the loss of electrical power which the plt did not recognize before the battery had been drained. During the precautionary landing the acft landed hard resulting in…NTSB LAX88LA164Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Florence, AZDuring a cross country flight, the engine suddenly quit, restarted, then quit completely. A forced landing was made in a dry wash where the aircraft nosed over during the landing roll. Approximately 4 gallons of fuel was drained from the fuel system. There…NTSB LAX88FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Essex, CAFailure of the pilot to maintain sufficient altitude to ensure terrain clearance while mountain flying.NTSB LAX88FA163Accident · 2 fatalField investigationFinal reportAerospatiale AS355F · Cajon, CAPilot's failure to maintain altitude.