NTSB investigations, 2012, ME

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 2012, 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\") = 2012
    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 ERA13FA059Accident · 3 fatalField investigationFinal reportCessna 172N · Owls Head, METhe vehicle driver's failure to verify that the runway was not occupied by an airplane before crossing the runway, which resulted in the vehicle being struck by a departing airplane, and the pilot's continued takeoff with flight control damage, which…Nov 16, 2012 · N6142F · Substantial damageNTSB ERA13CA010Accident · Minor injuriesData collectionFinal reportMoulton Howard Wells ULTRA-PUP · Lyman, METhe accumulation of ice in the automotive engine’s carburetor, which resulted in a loss of engine power.Oct 6, 2012 · N3073X · Substantial damageNTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.Aug 9, 2012 · N9838M · Substantial damageNTSB ERA12CA499Accident · No injuriesData collectionFinal reportAeronca 7CCM · Norridgewock, METhe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Aug 7, 2012 · N83129 · Substantial damageNTSB ERA12CA485Accident · No injuriesData collectionFinal reportBayliss Milton A III X-AIR · Houlton, METhe pilot's failure to maintain directional control during the landing flare in a gusting crosswind, which resulted in a runway excursion.Jul 26, 2012 · N8076E · Substantial damageNTSB ERA12LA480Accident · No injuriesLimited investigationFinal reportCessna A185F · Mapleton, METhe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his use of an improper engine restart procedure.Jul 22, 2012 · N5168E · Substantial damageNTSB ERA12CA461Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Sanford, METhe student pilot’s inadequate landing flare and improper recovery from a bounced landing.Jul 13, 2012 · N602PS · Substantial damageNTSB ERA12LA411Accident · 1 fatalLimited investigationFinal reportUniversal Stinson 108 · Portland, MEA fatigue failure of the No. 3 piston skirt, which resulted in a total loss of engine power and the subsequent ditching in the ocean.Jun 24, 2012 · N39443 · Substantial damageNTSB ERA12LA397Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Biddeford, MEA total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.Jun 15, 2012 · N3812V · Substantial damageNTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…Mar 20, 2012 · N46492 · Substantial damageNTSB ERA12LA230Accident · Serious injuriesLimited investigationFinal reportSadler Terry A Merlin · Otisfield, METhe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was his lack of experience in the airplane make and model.Mar 17, 2012 · N6113Y · Substantial damage