NTSB investigations, 1997, ME

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1997, ME per year, 1962–2026: 1,006 cases
19621
196427
196519
196634
196729
196838
196917
197013
197128
197240
197332
197423
197525
197626
197732
197825
197927
198021
198117
198218
198317
198422
198515
198616
198714
198815
198916
199012
199119
199220
199322
199419
199512
199614
19977
199810
199913
200012
200115
200210
200310
200412
20059
200614
20079
200813
200914
201010
201116
201211
20138
20148
20154
20167
20178
20184
201911
20206
20213
20225
20236
20249
20258
20269

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\") = 1997
    AND c.\"eventStateOrRegion\" = 'ME' 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 NYC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185 · Norway, METhe pilot's failure to maintain control of the airplane while maneuvering to avoid an obstacle.Jul 25, 1997 · N8717Z · Substantial damageNTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.Jul 3, 1997 · N3896T · DestroyedNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB NYC97LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clayton Lake, MEthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall, and uncontrolled descent to the frozen lake surface.Mar 28, 1997 · N2852M · DestroyedNTSB NYC97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, MEthe pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…Mar 14, 1997 · N2914A · Substantial damageNTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.Feb 19, 1997 · N7811E · Substantial damageNTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…Jan 10, 1997 · N139ZV · Substantial damage