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 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…Apr 27, 1988 · N79P · DestroyedNTSB 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…Apr 27, 1988 · N2730T · Substantial damageNTSB 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…Apr 26, 1988 · N9712B · Substantial damageNTSB 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…Apr 26, 1988 · N4835B · Substantial damageNTSB 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…Apr 25, 1988 · N312X · DestroyedNTSB 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…Apr 25, 1988 · N4528V · Substantial damageNTSB 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…Apr 25, 1988 · N5873M · Substantial damageNTSB 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…Apr 25, 1988 · N47966 · DestroyedNTSB 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…Apr 25, 1988 · N4226V · Substantial damageNTSB 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…Apr 25, 1988 · N9569P · Substantial damageNTSB DCA88WA057Incident · No injuriesForeign investigationMaule M4 · Watson Lake, CanadaApr 25, 1988 · N2053U · No damageNTSB 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…Apr 25, 1988 · N80269 · Substantial damageNTSB ATL88FA155Accident · Serious injuriesField investigationFinal reportCessna 150L · Knoxville, TNApr 25, 1988 · N1491Q · DestroyedNTSB 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…Apr 25, 1988 · N91290 · Substantial damageNTSB 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…Apr 24, 1988 · N61027 · Substantial damageNTSB BFO88DIG02Accident · 1 fatalFinal reportLamb Shoestring S-102 · Gaithersburg, MDThe pilot inproperly performing aerobatics without sufficient altitude to complete a recovery.Apr 24, 1988 · N47CL · DestroyedNTSB 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…Apr 24, 1988 · N5921T · Substantial damageNTSB 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…Apr 23, 1988 · N2924R · DestroyedNTSB 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…Apr 23, 1988 · N1394A · DestroyedNTSB 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…Apr 23, 1988 · N86128 · Substantial damageNTSB 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…Apr 22, 1988 · N9603L · Substantial damageNTSB 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…Apr 22, 1988 · N1414U · Substantial damageNTSB 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.Apr 22, 1988 · N3LB · Substantial damageNTSB 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…Apr 22, 1988 · N45BD · 2 aircraft · DestroyedNTSB 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…Apr 22, 1988 · N804MX · Minor damageNTSB ATL88FA150Accident · Minor injuriesField investigationFinal reportCessna 152 · Moncks Corner, SCApr 22, 1988 · N94251 · Substantial damageNTSB 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.Apr 21, 1988 · N81893 · Substantial damageNTSB 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…Apr 21, 1988 · N58110 · DestroyedNTSB 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…Apr 21, 1988 · N2720F · DestroyedNTSB DCA88WA055Accident · 2 fatalForeign investigationMcdonnell Douglas DC-3 · Mozambique-Sa, MozambiqueApr 21, 1988 · N47FE · DestroyedNTSB 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…Apr 21, 1988 · N9410U · Substantial damageNTSB 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.Apr 20, 1988 · N366X · Substantial damageNTSB 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…Apr 20, 1988 · N60358 · Substantial damageNTSB 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…Apr 20, 1988 · N8847X · Substantial damageNTSB 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…Apr 20, 1988 · N7979L · DestroyedNTSB 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…Apr 19, 1988 · N7657V · DestroyedNTSB 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…Apr 19, 1988 · N704MF · DestroyedNTSB 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…Apr 19, 1988 · N59981 · No damageNTSB 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…Apr 19, 1988 · N6915 · DestroyedNTSB 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…Apr 19, 1988 · N51205 · Substantial damageNTSB 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…Apr 18, 1988 · N2322F · Substantial damageNTSB 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.Apr 18, 1988 · N6583C · Minor damageNTSB 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…Apr 18, 1988 · N2326L · Substantial damageNTSB 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…Apr 18, 1988 · N65185 · Substantial damageNTSB 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…Apr 17, 1988 · N9892K · Substantial damageNTSB 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.Apr 17, 1988 · N4893L · DestroyedNTSB 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…Apr 17, 1988 · N2032M · Substantial damageNTSB 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…Apr 17, 1988 · N5504S · Substantial damageNTSB LAX88FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Essex, CAFailure of the pilot to maintain sufficient altitude to ensure terrain clearance while mountain flying.Apr 17, 1988 · N1681J · DestroyedNTSB LAX88FA163Accident · 2 fatalField investigationFinal reportAerospatiale AS355F · Cajon, CAPilot's failure to maintain altitude.Apr 17, 1988 · N5777P · Destroyed