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 NYC92DGM01Accident · 1 fatalFinal reportWillkins-Wayne VARI-VIGGEN · Erie, PAThe pilot lost control of the airplane at too low an altitude to recover. Factors related to the accident were the pilot's low time and experience in this type of airplane.Nov 13, 1991 · N12VV · DestroyedNTSB ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.Nov 13, 1991 · N49GA · Substantial damageNTSB MIA92WA026Accident · 2 fatalForeign investigationPiper PA-34-200T · Atlantic Ocean (Atlantic Ocean)Nov 12, 1991 · N2898C · DestroyedNTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.Nov 12, 1991 · N8172A · Substantial damageNTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.Nov 12, 1991 · N9161P · Substantial damageNTSB ANC92LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Moose Pass, AKThe pilot's premature lift-off, causing the airplane to settle back to the ground. Contributing to the accident was the pilot's loss of directional control after settling back on the runway, due to his visibility being restricted by frost on the windshield.Nov 11, 1991 · N6742A · Substantial damageNTSB LAX92LA042Accident · No injuriesLimited investigationFinal reportBeech D18S · Hilo, HIThe aircraft's lack of single engine performance to maintain altitude after the engine lost power. Factors related to the accident were: displacement/mechanical interference within the accessory drive gear system of the left engine, failure of the left engine…Nov 10, 1991 · N4193 · Substantial damageNTSB LAX92FA043Accident · 3 fatalField investigationFinal reportCessna 172M · Carmel Valley, CAThe pilot's failure to maintain a safe altitude above the ground during an intentional low altitude flight in mountainous terrain. Contributing factors related to the pilot becoming distracted while flying over the ground and to his failure to initiate a…Nov 10, 1991 · N80274 · DestroyedNTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.Nov 10, 1991 · N9296T · No damageNTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.Nov 10, 1991 · N5015D · Substantial damageNTSB NYC92LA028Accident · Serious injuriesLimited investigationFinal reportBeech C99 · Syracuse, NYThe failure of the co-pilot to remain clear of the rotating propeller due to diversion of attention.Nov 9, 1991 · N3063W · Minor damageNTSB LAX92LA041Accident · Serious injuriesLimited investigationFinal reportBell 206B · Hilo, HIThe inadvertent encounter with a loss of tail rotor effectiveness phenomena and the resultant pilot inflight loss of control.Nov 9, 1991 · N16712 · Substantial damageNTSB CHI92LA024Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Burlington, IAThe pilot having an improper fuel tank selector position.Nov 9, 1991 · N38036 · Substantial damageNTSB ATL92LA022Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3101 · Memphis, TNThe failure of the ramp agent to position an additional step below the last step of the airstair door and the ground; the agent failed to follow a verbal company procedure.Nov 9, 1991 · N311PX · No damageNTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.Nov 8, 1991 · N5736B · DestroyedNTSB MIA92WA025Accident · 1 fatalForeign investigationPiper PA-30 · MissingNov 8, 1991 · N8410Y · DestroyedNTSB MIA92GA024Accident · 1 fatalFinal reportCessna 172N · Okeechobee, FLThe pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.Nov 8, 1991 · N739WS · DestroyedNTSB LAX92LA040Accident · No injuriesLimited investigationFinal reportMaule M4-220C · Coolidge, AZThe pilot's failure to maintain directional control of the aircraft during the takeoff ground run due to inadequate compensation for the existing wind conditions. A factor in this accident was the unfavorable wind reported by the pilot.Nov 8, 1991 · N40625 · Substantial damageNTSB CHI92FA023Accident · 1 fatalField investigationFinal reportCessna 150K · Kiowa, KSThe pilot-in-command's failure to properly utilize the carburetor heat to avoid loss of engine power due to carburetor icing. Factors contributing to the accident were the pilot-in-command's inattention and the encounter of unsuitable terrain during an…Nov 8, 1991 · N5732G · Substantial damageNTSB ATL92LA021Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wilson, NCThe intentional operation of the aircraft with a known deficiency and inadequate preflight inspection by the pilot.Nov 8, 1991 · N84399 · Substantial damageNTSB ATL92FA020Accident · 1 fatalField investigationFinal reportPiper PA-24 · Engelhard, NCThe spatial disorientation experienced by the pilot, and his inadvertent descent into the terrain. A factor was the dark, night lighting condition at the time of the accident.Nov 8, 1991 · N7120P · DestroyedNTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNov 8, 1991 · N1685A · Substantial damageNTSB ANC92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's loss of control during final approach when his attention was diverted to trying to operate the vernier throttle. Contributing to the accident was the pilot's lack of familiarity with the aircraft and his failure to maintain directional control of…Nov 8, 1991 · N4285H · Substantial damageNTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.Nov 7, 1991 · N29348 · Substantial damageNTSB ANC92LA014Accident · No injuriesLimited investigationFinal reportCessna 170 · Whiskey Gulch, AKThe pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.Nov 7, 1991 · N2584V · Substantial damageNTSB MIA92WA023Accident · 1 fatalForeign investigationGrumman G-164B · La Romana, Dominican RepublicNov 6, 1991 · N90514 · DestroyedNTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.Nov 6, 1991 · N3474S · Substantial damageNTSB FTW92LA020Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Epps, LAThe loss of 1/2 of a propeller blade. Factors were powerplant vibration and resultant powerplant separation.Nov 6, 1991 · N4546 · Substantial damageNTSB BFO92LA008Accident · No injuriesLimited investigationFinal reportMooney 20F · Basye, VAThe pilot misjudged the altitude and distance to the runway. Factors were the gusty weather conditions and the pilot's delay in executing a go around.Nov 6, 1991 · N9326V · Substantial damageNTSB MIA92LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Coleman, FLFailure of the unqualified pilot to maintain the proper glidepath while on final approach. Also, failure to perform the correct remedial action resulting in the collision with a power line.Nov 5, 1991 · N7823E · Substantial damageNTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.Nov 5, 1991 · N195MD · Substantial damageNTSB NYC92LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R · Caldwell, NJThe pilot allowed the airplane to get too low on final approach during a night visual landing. Factors in the accident were: the pilot improperly planned the approach, dark night and a lack of flight experience in night operations.Nov 4, 1991 · N9207K · DestroyedNTSB LAX92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williams, AZThe pilot's failure to maintain visual lookout.Nov 4, 1991 · N5337K · DestroyedNTSB LAX92LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Sacramento, CAThe partial failure of the brake system due to contamination.Nov 4, 1991 · N2802A · Substantial damageNTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…Nov 3, 1991 · N6AN · DestroyedNTSB NYC92FA025Accident · 2 fatalField investigationFinal reportBeech V35B · Newfield, NJInflight collision with the ground for undetermined reasons.Nov 3, 1991 · N1WT · DestroyedNTSB LAX92LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft after it settled back onto the runway following a premature takeoff rotation. A factor in the accident was the lack of total experience of the pilot.Nov 3, 1991 · N4933B · Substantial damageNTSB NYC92LA024Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Jim Thorpe, PAThe pilot's improper use of carburetor heat, resulting in carburetor ice and a loss of engine power and subsequent forced landing in trees. A factor related to the accident was the pilot's lack of experience in this make and model airplane.Nov 2, 1991 · N5634K · Substantial damageNTSB MIA92IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-31 · Gulf Of MexicoThe overfilling of the forward lavatory during servicing and the failure to replace the fill/rinse line cap after servicing by the ground service personnel which resulted in the lavatory venting fluid through the fill/rinse line during flight and the…Nov 2, 1991 · N839TW · Minor damageNTSB LAX92LA038Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe pilot's inability to control the aircraft during the landing roll due to a failure of the left brake and nose wheel steering systems. The failure of the brake and steering systems was due to a deterioration of the 'o' ring seals caused by the use of…Nov 2, 1991 · N71T · Substantial damageNTSB LAX92LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · San Diego, CAThe total loss of engine power due to unknown reason(s). A factor in this accident was the lack of suitable terrain to land the airplane, without incurring damage to the airplane.Nov 2, 1991 · N59157 · Substantial damageNTSB LAX92LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Riverside, CAThe failure of the engine to transmission drive belt and the pilots failure to correctly judge of the landing flare during the subsequent autorotation.Nov 2, 1991 · N549SM · Substantial damageNTSB LAX92FA033Accident · 3 fatalField investigationFinal reportCessna 337F · Bullhead City, AZThe pilots failure to maintain a proper descent rate and to adequately judge the above ground altitude of the aircraft during the approach. Factors in the accident were: 1) the dark night conditions, 2) the pilot's degraded visual perceptive ability, and 3)…Nov 2, 1991 · N1734M · DestroyedNTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…Nov 2, 1991 · N61539 · Substantial damageNTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…Nov 2, 1991 · N8283E · DestroyedNTSB CHI92FA022Accident · 2 fatalField investigationFinal reportRockwell AC 690B · Milton, KSIncapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.Nov 2, 1991 · N799V · DestroyedNTSB ANC92LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Beluga, AKAn exhaust valve failure. Contributing to the accident was the rough, uneven terrain, and trees.Nov 2, 1991 · N68291 · Substantial damageNTSB MIA92LA021Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Okeechobee, FLOperation by the owner/pilot-in-command with known deficiencies in equipment and fuel starvation due to a blocked fuel line.Nov 1, 1991 · N8631H · Substantial damageNTSB LAX92LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Reedley, CAThe student pilot's improper use of the flight controls and his failure to maintain directional control of the aircraft. A contributing factor in the accident was the students lack of total experience.Nov 1, 1991 · N48760 · Substantial damageNTSB LAX92LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Van Nuys, CAThe inadvertent loss of control during the initial climb after takeoff that resulted from the collapse of the rudder pedal because of a worn locking pin hole in the rudder pedal stowing system, which allowed the pin to disengage.Nov 1, 1991 · N93054 · Substantial damage