NTSB investigations, 1991, CT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 per year

19622026
NTSB investigations, 1991, CT per year, 1962–2026: 1,081 cases
19621
196432
196545
196650
196748
196834
196931
197034
197140
197231
197334
197424
197522
197618
197727
197826
197926
198021
198114
198222
198321
198433
198517
198623
198724
198817
198918
199017
199115
199221
199315
199413
199510
199614
19978
199816
199910
20009
200115
200212
20038
200413
20059
20067
20077
20089
20092
20104
201111
20126
20137
20145
20159
20168
201713
20188
20198
20205
20215
20225
20236
20246
20259
20263

Latest cases

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
  WHERE year(c.\"eventDate\") = 1991
    AND c.\"eventStateOrRegion\" = 'CT' AND c.\"eventCountry\" = 'USA'
  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 NYC92FA052Accident · 2 fatalField investigationFinal reportAeronca 7AC · Salisbury, CTThe pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…Dec 28, 1991 · N3103E · DestroyedNTSB NYC92LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Stratford, CTWater/ice in the fuel system, which resulted in fuel starvation and a loss of engine power. Factors related to the accident were: freezing temperatures and inadequate pre-flight preparation by the pilot.Dec 26, 1991 · N9423P · DestroyedNTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.Nov 28, 1991 · N25262 · Substantial damageNTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.Oct 27, 1991 · N14256 · Substantial damageNTSB NYC92LA005Accident · 1 fatalLimited investigationFinal reportAerospatiale ATR-42-320 · Bridgeport, CTThe employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.Oct 12, 1991 · N25811 · Minor damageNTSB NYC91LA249Accident · No injuriesLimited investigationFinal reportDavis D1K · Chester, CTImproper maintenance on the engine which resulted in a power loss due to a stuck exhaust valve and subsequent forced landing in unsuitable terrain.Sep 29, 1991 · N158Y · Substantial damageNTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…Jul 8, 1991 · N43ER · DestroyedNTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.Jun 9, 1991 · N2876Z · Substantial damageNTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…May 31, 1991 · N36069 · DestroyedNTSB NYC91LA130Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Ellington, CTThe failure of the pilot to maintain directional control, and his inadequate compensation for winds, while maneuvering close to the ground. A factor relating to the accident was the adverse wind conditions.May 12, 1991 · N496TP · Substantial damageNTSB NYC91FA125Accident · No injuriesField investigationFinal reportBoeing 727-100QC · Windsor Locks, CTA catastrophic and uncontained failure of the no.3 engine which resulted in a fuel fed fire.May 3, 1991 · N425EX · DestroyedNTSB NYC91LA124Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Oxford, CTThe failure of the pilot to maintain the proper landing descent rate and the resultant right main landing gear assembly collapse.May 1, 1991 · N445BL · Substantial damageNTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.Apr 6, 1991 · N64182 · Substantial damageNTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.Apr 4, 1991 · N7QG · Substantial damageNTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.Mar 21, 1991 · N4117N · Destroyed