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 ANC96LA003Accident · No injuriesLimited investigationFinal reportCessna 180K · Cold Bay, AKthe pilot's selection of an unsuitable area/terrain for landing. The submerged sandbar was a related factor.Oct 7, 1995 · N64337 · Substantial damageNTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.Oct 6, 1995 · N8845W · Substantial damageNTSB NYC96FA003Accident · 2 fatalField investigationFinal reportEnstrom 280C · Quakertown, PAimproper installation of the magneto by maintenance personnel, which resulted in the loss of ignition and the loss of engine power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Oct 6, 1995 · N976BT · DestroyedNTSB MIA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Spring Hill, FLThe pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…Oct 6, 1995 · N183JD · Substantial damageNTSB LAX96LA007Accident · No injuriesLimited investigationFinal reportSchlitter Rans S-9 · Chandler, AZseizure of the #2 cylinder for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Oct 6, 1995 · N5052E · Substantial damageNTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.Oct 6, 1995 · N625T · DestroyedNTSB BFO96LA003Accident · No injuriesLimited investigationFinal reportEnstrom F28-280C · Blue Ash, OHthe commercial pilot's failure to maintain clearance from obstacles during hover-taxi operations. Related factors the tailwind, the nearby obstacle, and the misjudged maneuver to avoid obstacles.Oct 6, 1995 · N51786 · Substantial damageNTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.Oct 6, 1995 · N6674Z · Substantial damageNTSB ANC96LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Healy, AKA failure of the pilot to adequately compensate for crosswind conditions. A factor in the accident was a crosswind.Oct 6, 1995 · N704UQ · Substantial damageNTSB ANC96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Hoonah, AKthe pilot's inadequate preflight planning/preparation. Factors relating to the accident were: improper weight and balance configuration, and unsuitable terrain in the emergency landing area.Oct 6, 1995 · N4024J · Substantial damageNTSB FTW96LA008Accident · Minor injuriesLimited investigationFinal reportBell 47-G2 · Freer, TXthe pilot's failure to maintain clearance from the power lines due to his improper takeoff technique. A factor was the helicopter induced blowing dust which impaired the pilot's visibility.Oct 5, 1995 · N4423 · Substantial damageNTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Oct 5, 1995 · N9873 · Substantial damageNTSB BFO96LA002Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Annapolis, MDthe pilot's improper planning/decision, and/or failure to go around while there sufficient airspeed and runway remaining during the approach/landing. Factors relating to the accident were: standing water on the runway, and resultant hydroplaning conditions.Oct 5, 1995 · N6648W · Substantial damageNTSB SEA96LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Ola, IDThe pilot's inadequate preflight preparation by failing to determine that the takeoff area was clear of obstructions. The rock was a factor.Oct 4, 1995 · N70221 · Substantial damageNTSB NYC96FA002Accident · 2 fatalField investigationFinal reportCessna 172N · Caton, NYThe pilot's improper IFR procedure by failing to maintain proper altitude, while on the initial approach for an ILS. A factor relating to the accident was: failure of the tower controller to issue a safety advisory.Oct 4, 1995 · N9461E · DestroyedNTSB MIA96LA002Accident · No injuriesLimited investigationFinal reportCessna T210M · Apopka, FLThe pilot's failure to perform fuel consumption calculations for the flight which resulted in a loss of engine power due to fuel exhaustion.Oct 4, 1995 · N6508B · Substantial damageNTSB FTW96LA006Accident · No injuriesLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXthe pilot's improper braking technique.Oct 4, 1995 · N20BD · Substantial damageNTSB FTW96LA005Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Edinburg, TXthe pilot's improper takeoff planning which resulted in the loss of conrol. A factor was the gusty crosswind condition.Oct 3, 1995 · N6SR · Substantial damageNTSB NYC96LA001Accident · No injuriesLimited investigationFinal reportCheney Avid Flyer · Newton, NHThe seizure of a piston during the takeoff climb, resulting in a loss of engine power, forced landing, and subsequent collision with trees.Oct 2, 1995 · N29GC · Substantial damageNTSB MIA96LA001Accident · Serious injuriesLimited investigationFinal reportClapp KR-2 · Jacksonville, FLThe pilot's inadequate preflight planning/preparation, failure to ensure proper weight and balance of the airplane, and failure to obtain or maintain sufficient airspeed during takeoff, which resulting in a stall and collision with wooded terrain.Oct 2, 1995 · N2CC · DestroyedNTSB LAX96LA002Accident · No injuriesLimited investigationFinal reportCessna 150M · Fillmore, CAthe CFI's failure to adequately supervise the flight; and the student pilot's poor preflight planning/preparation and fuel consumption calculations.Oct 2, 1995 · N63522 · Substantial damageNTSB LAX96LA001Accident · 1 fatalLimited investigationFinal reportMooney M20E · Long Beach, CAa loss of engine power for undeternined reasons.Oct 2, 1995 · N79820 · DestroyedNTSB FTW96FA004Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Roanoke, TXthe pilot's inadequate weather evaluation and encounter with a sudden windshift and tailwind. The wind gusts and turbulence were factors.Oct 2, 1995 · N85636 · Substantial damageNTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.Oct 2, 1995 · N152ND · Substantial damageNTSB SEA96LA001Accident · 1 fatalLimited investigationFinal reportRasmussen Kitfox 2 · Battle Ground, WAfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall/mush and subsequent collision with trees and the ground.Oct 1, 1995 · N488WR · DestroyedNTSB LAX95LA347Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAthe second pilot's failure to maintain directional control and the first pilot's improper supervision of the flight.Oct 1, 1995 · N68225 · Substantial damageNTSB LAX95LA346Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Avondale, AZthe pilot's failure to plan to avoid wake turbulence.Oct 1, 1995 · N6779K · Substantial damageNTSB FTW96LA002Accident · No injuriesLimited investigationFinal reportBeech A36 · Cotulla, TXThe pilot's delay in aborting the takeoff. A factor was the pilot's improper use of the aircraft performance data.Oct 1, 1995 · N7247W · Substantial damageNTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.Oct 1, 1995 · N63286 · Substantial damageNTSB CHI96LA001Accident · No injuriesLimited investigationFinal reportLuscombe Phantom 1 · Rolla, MOmechanical failure of the left brake.Oct 1, 1995 · N272Y · Substantial damageNTSB BFO96LA001Accident · No injuriesLimited investigationFinal reportRudy Kitfox 1 · Charlottesville, VAthe pilot's improper fuel management which resulted in fuel exhaustion. A related factor was the pilot's inadequate fuel consumption calculations.Oct 1, 1995 · N226WR · DestroyedNTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.Oct 1, 1995 · N9553H · Substantial damageNTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.Sep 30, 1995 · N1953P · Substantial damageNTSB LAX95LA345Accident · Minor injuriesLimited investigationFinal reportPro-built Kitfox IV Speedster · Lakeport, CAthe pilot's improper installation of the carburetors.Sep 30, 1995 · N42RA · Substantial damageNTSB FTW95FA407Accident · 1 fatalField investigationFinal reportBeech A36 · Brady, TXthe pilot's improper decision to attempt a night landing without the visual cues necessary to establish runway alignment. Factors were the dark night light condition, the inoperative runway edge lights, and the failure of airport management to issue a NOTAM…Sep 30, 1995 · N836AA · DestroyedNTSB CHI95LA338Accident · No injuriesLimited investigationFinal reportHelio U-10D · Wellsville, KSThe pilot's improper weather evaluation. A factor was the pilot's inadequate compensation for the wind conditions.Sep 30, 1995 · N2706J · Substantial damageNTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.Sep 29, 1995 · N167K · Substantial damageNTSB NYC95LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rutland, VTLoss of engine power during takeoff for undetermined reason(s), which resulted in a forced landing and subsequent collision with a tree and barn.Sep 29, 1995 · N3203Q · Substantial damageNTSB NYC95LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Warminster, PAthe pilot's improper positioning of the fuel selector which resulted in a total loss of engine power due to fuel starvation. A contributing factor was pilot distraction.Sep 29, 1995 · N33330 · Substantial damageNTSB NYC95LA227Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pittsburgh, PAthe pilot's failure to obtain the proper touchdown point and excessive airspeed which resulted in an overrun and a subsequent collision with a trailer off the departure end of the runway.Sep 29, 1995 · N9497B · Substantial damageNTSB MIA95LA241Accident · Minor injuriesLimited investigationFinal reportBeech D50E · Okeechobee, FLThe pilot's decision to conduct a feathering check of the right propeller at an altitude inadequate for a safe engine restart or refeathering of the propeller.Sep 29, 1995 · N9351Y · Substantial damageNTSB MIA95LA240Accident · Minor injuriesLimited investigationFinal reportMenear Pitts S-1S · Boynton Beach, FLThe pilot's improper decision to make a go-around and failure to maintain airspeed (vso) resulting in an inadvertent stall. The total loss of engine power due to fuel exhaustion was a factor.Sep 29, 1995 · N21WM · Substantial damageNTSB LAX95LA344Accident · 2 fatalLimited investigationFinal reportCessna 172H · St. Johns, AZthe pilot's failure to assure that the seat adjustment pin was properly engaged prior to takeoff.Sep 29, 1995 · N8034L · DestroyedNTSB ATL95LA176Accident · No injuriesLimited investigationFinal reportCessna 182R · Tuscaloosa, ALEngine oil starvation for undetermined reasons, which resulted in a connecting rod cap failure.Sep 29, 1995 · N9119C · Substantial damageNTSB SEA95LA228Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAfailure of the pilot to properly flare the airplane during the landing. Factors relating to the accident were: the pilot's improper approach to land, exceeding the proper touchdown point for landing, failure to go-around, while there was sufficient runway…Sep 28, 1995 · N5949E · Substantial damageNTSB NYC95LA228Accident · No injuriesLimited investigationFinal reportCessna 150M · Rutland, VTthe loss of engine power for an undetermined reason.Sep 28, 1995 · N9289U · Substantial damageNTSB MIA95FA239Accident · 1 fatalField investigationFinal reportBeech 58 · Greer, SCoperation of the aircraft by the pilot with a known deficiency (failed mixture control linkage in the right engine), which resulted in loss of power in the right engine; and his failure to maintain control of the airplane during the initial climb after…Sep 28, 1995 · N4095A · DestroyedNTSB LAX95LA349Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Placerville, CAthe student pilot's failure to obtain a proper descent rate and improper remedial by failing to initiate a go-around. The inadvertent stall and the gusty wind conditions were factors in this accident.Sep 28, 1995 · N2481F · Substantial damageNTSB LAX95LA342Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Phoenix, AZthe pilot's inadequate preflight planning and improper fuel consumption calculations. The soft terrain was a factor in this accident.Sep 28, 1995 · N6500W · Substantial damageNTSB LAX95FA341Accident · Minor injuriesField investigationFinal reportBeech A36 · Van Nuys, CAthe pilot's fuel mismanagement and failure to assure that an adequate supply of fuel was available. His lack of familiarity with the airplane's fuel system, overcofidence, the dark night, and the lack of a suitable landing area were factors in the accident.Sep 28, 1995 · N15278 · Substantial damage