NTSB investigations, RI

112 cases where the phase of flight was Landing.

Cases, newest first

Query with SQL
duckdb -csv -c "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 = 550)
  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 NYC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182P · Block Island, RIThe acft veered off the runway during landing and collided with a ditch. The approach to Block Island was normal and thelanding was made about one third down the runway. On touchdown, directional control was lost and the acft veered to the left side of the…Apr 13, 1983 · N575PM · Substantial damageNTSB NYC82DA044Accident · No injuriesFinal reportCessna 182RG · Smithfield, RIAccording to the pilot, while on final approach to runway 33, a severe downdraft was experienced and he was unable to recover. He landed short of the runway on firm grass, bounced and came to rest a short distance from the downwind end of the runway.…Mar 2, 1982 · N1837R · Substantial damageNTSB NYC81FNA16Accident · Minor injuriesClosedCessna 172N · Cranston, RIMay 29, 1981 · N3543E · Substantial damageNTSB NYC81DNA04Accident · No injuriesClosedBell 206B · Warwick, RIDec 2, 1980 · N2775F · Substantial damageNTSB NYC80FNA28Accident · No injuriesClosedBellanca 7KCAB · Lincoln, RISep 30, 1980 · N41694 · Substantial damageNTSB NYC80FNA07Accident · Minor injuriesClosedBeech B23 · Block Island, RIJan 8, 1980 · N6699S · Substantial damageNTSB NYC79FNA25Accident · Serious injuriesClosedGrum Amer AA1B · W.Greenwich, RIJul 23, 1979 · N9678L · Substantial damageNTSB NYC78FNA36Accident · No injuriesClosedLuscombe 8A · Kingstown, RIJul 10, 1978 · N1352K · Substantial damageNTSB NYC78FNA33Accident · No injuriesClosedCurtiss C 12Q · Westerly, RIJun 25, 1978 · N370N · Substantial damageNTSB NYC78FNA30Accident · No injuriesClosedPiper PA-24 · Block Island, RIJun 14, 1978 · N7900P · Substantial damageNTSB NYC78FNA06Accident · No injuriesClosedAeronca 7AC · Lincoln, RIJan 24, 1978 · N83865 · Substantial damageNTSB NYC77FNA05Accident · No injuriesClosedCessna 172M · West Kingston, RINov 24, 1976 · N64238 · Substantial damageNTSB NYC76DNA49Accident · No injuriesClosedCessna 120 · Block Island, RIAug 26, 1976 · N1808N · Substantial damageNTSB NYC76FNA30Accident · No injuriesClosedPiper PA-23 · Warwick, RIMar 8, 1976 · N2277P · Substantial damageNTSB NYC76FNA19Accident · No injuriesClosedBeech D55 · Warwick, RIOct 21, 1975 · N222AS · Substantial damageNTSB NYC75FNA33Accident · No injuriesClosedPiper PA-23 · Lincoln, RIMar 2, 1975 · N40245 · Substantial damageNTSB NYC75FNA23Accident · No injuriesClosedLuscombe 8F · Block Island, RIOct 24, 1974 · N37087 · Substantial damageNTSB NYC75FNA18Accident · Minor injuriesClosedCessna 172 · Block Island, RISep 22, 1974 · N6206E · DestroyedNTSB NYC75DNA07Accident · No injuriesClosedBeech G35 · Pawtucket, RIJul 28, 1974 · N135JL · Substantial damageNTSB NYC74DNA44Accident · No injuriesClosedCessna 150H · Slocum, RIMay 18, 1974 · N50439 · Substantial damageNTSB NYC74AN081Accident · No injuriesClosedPiper PA-31 · Providence, RIMar 15, 1974 · N9057Y · Substantial damageNTSB NYC74FNA08Accident · No injuriesClosedPiper PA-24 · Lincoln, RIAug 5, 1973 · N5290P · Substantial damageNTSB NYC73FNA51Accident · Minor injuriesClosedCessna 150 · Tiverton, RIJun 3, 1973 · N6517T · Substantial damageNTSB NYC73DNA16Accident · No injuriesClosedBeech B35 · Block Island, RIAug 25, 1972 · N8874A · Substantial damageNTSB NYC73DNA15Accident · No injuriesClosedCessna 172L · Block Island, RIAug 22, 1972 · N7604G · Substantial damageNTSB NYC72FNA46Accident · No injuriesClosedCessna 337B · Warwick, RIJun 25, 1972 · N44LB · Substantial damageNTSB NYC72DNA40Accident · No injuriesClosedPiper PA-28 · Lincoln, RIMay 7, 1972 · N98285 · Substantial damageNTSB NYC72DNA04Accident · No injuriesClosedPiper PA-28 · Block Island, RIJul 28, 1971 · N9524J · Substantial damageNTSB NYC71FFD41Accident · No injuriesClosedPiper PA-24 · Lincoln, RIMar 30, 1971 · N8233P · Substantial damageNTSB NYC71FFD38Accident · No injuriesClosedPiper PA-24 · Smithfield, RIFeb 6, 1971 · N1Q · Substantial damageNTSB NYC70DFD20Accident · No injuriesClosedPiper PA-22 · Smithfield, RIMay 28, 1970 · N4932Z · Substantial damageNTSB NYC70AN110Accident · 1 fatalClosedCessna 150B · Cranston, RIApr 5, 1970 · N1198Y · DestroyedNTSB NYC70AN090Accident · No injuriesClosedLear Jet 24B · Warwick, RIFeb 15, 1970 · N754M · Substantial damageNTSB NYC70A0035Accident · No injuriesClosedN.American NA-265 · Westerly, RISep 18, 1969 · N881MC · Substantial damageNTSB NYC70D0041Accident · No injuriesClosedBeech C55 · Block Island, RIJun 26, 1969 · N9562Q · Substantial damageNTSB NYC69F0441Accident · No injuriesClosedCessna 150F · Coventry, RIMay 13, 1969 · N8066S · Substantial damageNTSB NYC69A0083Accident · No injuriesClosedPiper PA-30B · Warwick, RIFeb 26, 1969 · N8555Y · Substantial damageNTSB NYC69A0037Accident · No injuriesClosedPiper PA-28 · Lincoln, RISep 19, 1968 · N6690J · 2 aircraft · Minor damageNTSB NYC69D0099Accident · No injuriesClosedBeech T-34A · Lincoln, RIAug 1, 1968 · N5504A · Substantial damageNTSB NYC69D0112Accident · No injuriesClosedLuscombe 8F · Westerly, RIJul 20, 1968 · N1885B · Substantial damageNTSB NYC68D0366Accident · No injuriesClosedCessna 210F · Slocum, RIFeb 11, 1968 · N5811F · Substantial damageNTSB NYC68D0148Accident · No injuriesClosedPiper PA-30 · Block Island, RIAug 18, 1967 · N7324Y · Substantial damageNTSB NYC68D0158Accident · No injuriesClosedCessna 140 · No-Kingstown, RIMay 30, 1967 · N72708 · Substantial damageNTSB NYC68F0127Accident · No injuriesClosedStinson V-77 · Lincoln, RIMay 20, 1967 · N69985 · Substantial damageNTSB NYC68F0180Accident · No injuriesClosedCessna 310K · Block Island, RIMay 4, 1967 · N6921L · Substantial damageNTSB NYC67D0637Accident · No injuriesClosedPiper PA-22 · Coventry, RIApr 25, 1967 · N2469A · Substantial damageNTSB NYC67D0624Accident · No injuriesClosedCessna 172E · Block Island, RIMar 25, 1967 · N3500S · Substantial damageNTSB NYC67F0478Accident · No injuriesClosedPiper PA-24 · Lincoln, RIJan 29, 1967 · N9002P · Substantial damageNTSB NYC67F0409Accident · No injuriesClosedNavion A · Warwick, RIDec 15, 1966 · N91454 · Substantial damageNTSB NYC67F0403Accident · No injuriesClosedMooney M20C · Smithfield, RINov 23, 1966 · N1384W · Substantial damage