# NTSB investigations, ME: Standing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA15CA095](https://openairdocs.org/ntsb/ERA15CA095.md): Cessna A185E · Lewiston, ME · Accident · No injuries · Data collection · Final report · Jan 7, 2015 · N70037 · Substantial damage
  > The pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.
- [NTSB NYC06IA226](https://openairdocs.org/ntsb/NYC06IA226.md): Cessna 206F · Matinicus Islnd, ME · Incident · No injuries · Incident investigation · Final report · Sep 1, 2006 · N8411Q · Minor damage
  > An engine kick back of undetermined origin during engine start.
- [NTSB NYC04LA060](https://openairdocs.org/ntsb/NYC04LA060.md): Stinson 108-3 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Jan 25, 2004 · N6234M · Destroyed
  > An engine fire for undetermined reasons during start-up.
- [NTSB NYC00LA070](https://openairdocs.org/ntsb/NYC00LA070.md): Cessna 150 · Wiscasset, ME · Accident · No injuries · Limited investigation · Final report · Jan 29, 2000 · N7854E · Substantial damage
  > The pilot's inadequate preflight inspection.
- [NTSB NYC94LA041](https://openairdocs.org/ntsb/NYC94LA041.md): Cessna 172N · Bar Harbor, ME · Accident · No injuries · Limited investigation · Final report · Dec 17, 1993 · N5753E · Substantial damage
  > A disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.
- [NTSB NYC88LA208](https://openairdocs.org/ntsb/NYC88LA208.md): Ercoupe 415C · Auburn-Lewiston, ME · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N169WS · Substantial damage
  > The student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.
- [NTSB NYC87LA168](https://openairdocs.org/ntsb/NYC87LA168.md): Taylorcraft DCO-65 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Apr 22, 1987 · N58032 · Substantial damage
  > The acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…
- [NTSB NYC78FNC51](https://openairdocs.org/ntsb/NYC78FNC51.md): Cessna 172M · Old Town, ME · Accident · Serious injuries · Closed · Sep 17, 1978 · N9604H · No damage
- [NTSB NYC76AN068](https://openairdocs.org/ntsb/NYC76AN068.md): Piper PA-28R · Auburn, ME · Accident · 1 fatal · Closed · Jan 24, 1976 · N2074T · No damage
- [NTSB NYC72FNC21](https://openairdocs.org/ntsb/NYC72FNC21.md): Stinson 108-3 · Princeton, ME · Incident · 1 fatal · Closed · Jan 7, 1972 · N6070M · Minor damage
- [NTSB NYC69A0094](https://openairdocs.org/ntsb/NYC69A0094.md): Piper PA-23 · Portland, ME · Accident · No injuries · Closed · Apr 18, 1969 · N5090Y · Substantial damage
- [NTSB NYC68D0145](https://openairdocs.org/ntsb/NYC68D0145.md): Taylorcraft BC12-D · Bethel, ME · Accident · No injuries · Closed · Aug 21, 1967 · N24321 · 2 aircraft · Substantial damage
- [NTSB NYC66F0044](https://openairdocs.org/ntsb/NYC66F0044.md): Taylorcraft BL-65 · Harrison, ME · Accident · No injuries · Closed · Jun 17, 1965 · N27672 · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 c."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?state=ME

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.