# NTSB investigations, RI: Takeoff

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 ERA21LA371](https://openairdocs.org/ntsb/ERA21LA371.md): Mooney M20K · New Shoreham, RI · Accident · No injuries · Class 4 · Limited · Final report · Jul 27, 2021 · N110CG · Substantial damage
  > The pilot’s improper decision to reject the takeoff at an excessive speed, resulting in a runway excursion and collision with a fence. Contributing to the accident was the pilot’s failure to lock the door as required by the placarded door closing procedures.
- [NTSB NYC08LA207](https://openairdocs.org/ntsb/NYC08LA207.md): Beech A36 · Pawtucket, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2008 · N27199 · 2 aircraft · Substantial damage
  > Both pilots' failure to see and avoid the other airplane. Contributing to the accident was the air traffic controllers failure to notify either pilot of the potential conflict.
- [NTSB ATL07CA124](https://openairdocs.org/ntsb/ATL07CA124.md): Cessna C172R · Pawtucket, RI · Accident · No injuries · Data collection · Final report · Aug 30, 2007 · N2459Y · Substantial damage
  > The student pilot's failure to maintain control of the aircraft during the takeoff roll.
- [NTSB NYC00LA117](https://openairdocs.org/ntsb/NYC00LA117.md): Mooney M20C · Middletown, RI · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2000 · N9187V · Substantial damage
  > an inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.
- [NTSB IAD97LA094](https://openairdocs.org/ntsb/IAD97LA094.md): Piper PA-28-161 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1997 · N80964 · Destroyed
  > The pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.
- [NTSB NYC96LA129](https://openairdocs.org/ntsb/NYC96LA129.md): Cessna 172C · Block Island, RI · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 1996 · N1665Y · Substantial damage
  > the pilot's inadequate preflight, by failing to remove the control lock and checking the flight controls before takeoff, and his failure to abort the takeoff in a timely manner, which resulted in an overrun, an encounter with brush, and a subsequent nose over…
- [NTSB NYC95LA163](https://openairdocs.org/ntsb/NYC95LA163.md): Helio H-295 · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Jun 30, 1995 · N316LM · Substantial damage
  > the failure of the crosswind castering gear to remain locked on the right main gear during the takeoff roll which resulted in directional control not possible.
- [NTSB NYC91LA216](https://openairdocs.org/ntsb/NYC91LA216.md): Cessna TU206G · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1991 · N756UF · Substantial damage
  > Improper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.
- [NTSB NYC87LA254](https://openairdocs.org/ntsb/NYC87LA254.md): Beech E55 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1987 · N4158A · Substantial damage
  > Just before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…
- [NTSB NYC82FNA08](https://openairdocs.org/ntsb/NYC82FNA08.md): Cessna 140 · Westerly, RI · Accident · No injuries · Closed · Nov 25, 1981 · N1856V · Substantial damage
- [NTSB NYC81FNA02](https://openairdocs.org/ntsb/NYC81FNA02.md): Cessna 172 · Warwick, RI · Accident · Minor injuries · Closed · Nov 26, 1980 · N73725 · Substantial damage
- [NTSB NYC79FNA27](https://openairdocs.org/ntsb/NYC79FNA27.md): Piper PA-23 · Newport, RI · Accident · No injuries · Closed · Aug 5, 1979 · N62664 · Substantial damage
- [NTSB NYC79FNA14](https://openairdocs.org/ntsb/NYC79FNA14.md): Cessna 172 · Newport, RI · Accident · No injuries · Closed · Apr 7, 1979 · N7062Q · Substantial damage
- [NTSB NYC78FNA23](https://openairdocs.org/ntsb/NYC78FNA23.md): Mooney M20C · Westerly, RI · Accident · No injuries · Closed · May 20, 1978 · N9474V · Substantial damage
- [NTSB NYC78FNA09](https://openairdocs.org/ntsb/NYC78FNA09.md): Piper PA-22 · Westerly, RI · Accident · No injuries · Closed · Feb 12, 1978 · N5632Z · Substantial damage
- [NTSB NYC76FNA36](https://openairdocs.org/ntsb/NYC76FNA36.md): Mooney M20F · New Shoreham, RI · Accident · No injuries · Closed · Apr 24, 1976 · N3470N · Substantial damage
- [NTSB NYC76DNA26](https://openairdocs.org/ntsb/NYC76DNA26.md): Cessna 172 · Block Island, RI · Accident · No injuries · Closed · Jan 17, 1976 · N20501 · Substantial damage
- [NTSB NYC76AN036](https://openairdocs.org/ntsb/NYC76AN036.md): Dassault Falcon · Warwick, RI · Accident · No injuries · Closed · Sep 27, 1975 · N25FE · Substantial damage
- [NTSB NYC76FNA05](https://openairdocs.org/ntsb/NYC76FNA05.md): Cessna 172M · Block Island, RI · Accident · No injuries · Closed · Jul 27, 1975 · N6657H · Substantial damage
- [NTSB NYC74DNA13](https://openairdocs.org/ntsb/NYC74DNA13.md): Piper J-3 · Greene, RI · Accident · No injuries · Closed · Sep 1, 1973 · N6987H · Substantial damage
- [NTSB NYC72DNA32](https://openairdocs.org/ntsb/NYC72DNA32.md): Mccullough J-2 · Newport, RI · Accident · No injuries · Closed · Feb 5, 1972 · N4314G · Substantial damage
- [NTSB NYC72DNA23](https://openairdocs.org/ntsb/NYC72DNA23.md): Piper PA-22 · Block Island, RI · Accident · No injuries · Closed · Dec 18, 1971 · N8537C · Substantial damage
- [NTSB NYC72AN026](https://openairdocs.org/ntsb/NYC72AN026.md): Aero Comdr 500-B · Newport, RI · Accident · No injuries · Closed · Aug 18, 1971 · N6367U · Substantial damage
- [NTSB NYC71AN045](https://openairdocs.org/ntsb/NYC71AN045.md): Aero Comdr 680-FL · Middletown, RI · Accident · No injuries · Closed · Jul 18, 1970 · N4528E · Substantial damage
- [NTSB NYC67F0054](https://openairdocs.org/ntsb/NYC67F0054.md): Luscombe 8E · Newport, RI · Accident · No injuries · Closed · Jul 12, 1966 · N1689K · 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" = 'RI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.