NTSB investigations, 2003, 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, 2003, 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\") = 2003
    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 NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.Nov 5, 2003 · N805TH · Minor damageNTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.Sep 14, 2003 · N10224 · Substantial damageNTSB NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.Sep 14, 2003 · N755FA · Substantial damageNTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.Sep 7, 2003 · N6445X · Substantial damageNTSB IAD03CA072Accident · No injuriesData collectionFinal reportCessna C-170 · Kennebunkport, METhe pilot's failure to obtain the proper touchdown point, which resulted in the abrupt maneuver and subsequent failure of the landing gear.Aug 31, 2003 · N11576 · Substantial damageNTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.Aug 17, 2003 · N8550U · Substantial damageNTSB NYC03FA129Accident · 2 fatalField investigationFinal reportCessna 150H · Pittsfield, METhe inadvertent resumption of power during a forced landing that resulted in a subsequent spin. Factors related to the accident were the CFI's delayed remedial action, the loss of engine power due to contaminated fuel, an obstructed fuel screen, and the…Jun 12, 2003 · N6566S · DestroyedNTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.May 4, 2003 · N46773 · Substantial damageNTSB NYC03LA055Accident · No injuriesLimited investigationFinal reportCessna 140 · Fryeburg, MEAn in-flight encounter with carburetor ice, which resulted in a total loss of engine power during a simulated engine failure.Feb 16, 2003 · N76897 · Substantial damageNTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.Jan 26, 2003 · N1484B · Substantial damage