# NTSB investigations: Enroute

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.

Page 91 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CEN12LA265](https://openairdocs.org/ntsb/CEN12LA265.md): Jonker Sailplanes CC JS 1B · Clines Corner, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2012 · N555AP · Substantial damage
  > The fatigue failure of the rudder cable due to the inadequate design of the rudder pedal system.
- [NTSB WPR12LA188](https://openairdocs.org/ntsb/WPR12LA188.md): Hawker Beech V35B · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 2012 · N2841W · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA12LA306](https://openairdocs.org/ntsb/ERA12LA306.md): Cessna 210 · Fowler's Bluff, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2012 · N6564X · Substantial damage
  > The pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA12WA353](https://openairdocs.org/ntsb/ERA12WA353.md): Embraer EMB712 · Morro do Manduba Guaruja, Brazil · Accident · 2 fatal · Foreign investigation · Apr 26, 2012 · PT-NUH · Substantial damage
  > On April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…
- [NTSB CEN12LA257](https://openairdocs.org/ntsb/CEN12LA257.md): Clifton Breezy · Laneville, TX · Accident · No injuries · Limited investigation · Final report · Apr 23, 2012 · N6155M · Substantial damage
  > A loss of engine power due to carburetor ice.
- [NTSB WPR12LA182](https://openairdocs.org/ntsb/WPR12LA182.md): Mays Kitfox Lite 2 · Cedarville, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2012 · N32122 · Substantial damage
  > A loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.
- [NTSB ERA12LA295](https://openairdocs.org/ntsb/ERA12LA295.md): Raytheon A36 · Yorktown, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2012 · N821SM · Substantial damage
  > The pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.
- [NTSB WPR12LA176](https://openairdocs.org/ntsb/WPR12LA176.md): Skykits USA Savannah ADV · Ookala, HI · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 2012 · N5089F · Substantial damage
  > A loss of engine power during cruise for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s failure to avoid an…
- [NTSB ERA12LA294](https://openairdocs.org/ntsb/ERA12LA294.md): Cessna 172R · Richmond, KY · Accident · No injuries · Limited investigation · Final report · Apr 19, 2012 · N28BC · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…
- [NTSB ERA12LA290](https://openairdocs.org/ntsb/ERA12LA290.md): Cessna 421C · Accident · 1 fatal · Limited investigation · Final report · Apr 19, 2012 · N48DL · Substantial damage
  > Pilot incapacitation, which resulted in the pilot’s inability to maintain airplane control and the airplane’s subsequent ocean impact.
- [NTSB DCA12CA062](https://openairdocs.org/ntsb/DCA12CA062.md): Airbus Industrie A319-132 · Buena Vista, CO · Accident · Serious injuries · Data collection · Final report · Apr 15, 2012 · N808AW · Minor damage
  > an inadvertent encounter with mountain wave turbulence.
- [NTSB ERA12FA280](https://openairdocs.org/ntsb/ERA12FA280.md): Manzitto Michael A Mwlancair 235 · Hudson, KY · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2012 · N235MW · Substantial damage
  > The pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.
- [NTSB CEN12LA242](https://openairdocs.org/ntsb/CEN12LA242.md): Bell 407 · Aberdeen, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2012 · N509MT · Substantial damage
  > The fatigue failure of two turbine engine blades due to vibration.
- [NTSB CEN12LA245](https://openairdocs.org/ntsb/CEN12LA245.md): Nelson Sydney/Nelson Diann Zodiac XL · Medina, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 2012 · N4337G · Substantial damage
  > A cracked fuel line, which resulted in a loss of fuel pressure and subsequent loss of engine power.
- [NTSB ERA12CA276](https://openairdocs.org/ntsb/ERA12CA276.md): Piper PA-28-151 · Iuka, MS · Accident · Minor injuries · Data collection · Final report · Apr 10, 2012 · N43003 · Substantial damage
  > The pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12LA274](https://openairdocs.org/ntsb/ERA12LA274.md): Cessna 172S · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 9, 2012 · N375LP · Substantial damage
  > A total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.
- [NTSB WPR12LA161](https://openairdocs.org/ntsb/WPR12LA161.md): Piper PA-28-181 · Casper, WY · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 2012 · N30997 · Substantial damage
  > A total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…
- [NTSB ERA12WA298](https://openairdocs.org/ntsb/ERA12WA298.md): Agusta A119 · Leningradsky, Russia · Accident · 4 fatal · Foreign investigation · Apr 6, 2012 · RA-01980 · Substantial damage
  > On April 6, 2012, about 1240 Universal Coordinated Time (UTC), an AgustaWestland S.p.A., A119 helicopter, Russian registration RA-01980, crashed onto a frozen lake (Yanisyarvi), Sortavalsk district, Leningradsky region, about 5 KM from camp Chernye Kamni,…
- [NTSB ERA12LA268](https://openairdocs.org/ntsb/ERA12LA268.md): Hawker Beechcraft C90GTX · Caribbean Sea, A1 · Accident · No injuries · Limited investigation · Final report · Apr 3, 2012 · N8116L · Substantial damage
  > A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…
- [NTSB ERA12LA267](https://openairdocs.org/ntsb/ERA12LA267.md): Piper PA-28R-200 · Eastover, SC · Accident · No injuries · Limited investigation · Final report · Apr 3, 2012 · N961JD · Substantial damage
  > Inadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…
- [NTSB CEN12LA224](https://openairdocs.org/ntsb/CEN12LA224.md): Cessna U206B · Winterset, IA · Accident · No injuries · Limited investigation · Final report · Apr 1, 2012 · N3830G · Substantial damage
  > The loss of oil pressure to the No. 4 connecting rod journal and the subsequent loss of engine power.
- [NTSB ERA12LA261](https://openairdocs.org/ntsb/ERA12LA261.md): Cessna 210-5 · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Mar 31, 2012 · N224AL · Substantial damage
  > The pilot's inadequate preflight preparation and fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA235](https://openairdocs.org/ntsb/CEN12LA235.md): Eurocopter SA315B · Alva, OK · Accident · No injuries · Limited investigation · Final report · Mar 30, 2012 · N929JV · Substantial damage
  > Failure of the current and previous operators to comply with the manufacturer's maintenance procedures for operation in sandy environments, which resulted in turbine case erosion and the subsequent uncontained engine failure.
- [NTSB CEN12FA217](https://openairdocs.org/ntsb/CEN12FA217.md): Oliver Joseph Zodiac CH 601XL · Belmont, OH · Accident · 1 fatal · Field investigation · Final report · Mar 30, 2012 · N8060J · Substantial damage
  > The loss of engine power and the pilot’s diverted attention to the engine power loss, which resulted in a rapid descent and impact with terrain.
- [NTSB ERA12LA258](https://openairdocs.org/ntsb/ERA12LA258.md): Rotorcraft Developement OH-58C · McComb, MS · Accident · No injuries · Limited investigation · Final report · Mar 27, 2012 · N452MC · Substantial damage
  > A total loss of engine power due to oil starvation at the Nos. 5 and 8 engine bearings, which resulted in a catastrophic engine failure.
- [NTSB WPR12LA146](https://openairdocs.org/ntsb/WPR12LA146.md): Jacobs RV-6A · Bow, WA · Accident · No injuries · Limited investigation · Final report · Mar 24, 2012 · N238RV · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the fuel supply.
- [NTSB ERA12LA253](https://openairdocs.org/ntsb/ERA12LA253.md): Piper PA-28-180 · Margaret, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 2012 · N7309W · Substantial damage
  > The pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power during cruise flight due to fuel starvation.
- [NTSB CEN12FA199](https://openairdocs.org/ntsb/CEN12FA199.md): Cessna 172S · Longmont, CO · Accident · 2 fatal · Field investigation · Final report · Mar 23, 2012 · N10468 · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.
- [NTSB ERA12WA249](https://openairdocs.org/ntsb/ERA12WA249.md): Beech 300 · Puerto Aguiree, Chile · Accident · 8 fatal · Foreign investigation · Mar 22, 2012 · CC-AEB · Destroyed
  > On March 22, 2012, at 0358 UTC, a Beech BE 300, Chilean registration CC-AEB registered to Banco Popular Espanol, S.A. and operated by Inaer Helicopter Chile SA as an air ambulance flight, departed controlled flight at Flight level 280 while in radio contact…
- [NTSB WPR12LA147](https://openairdocs.org/ntsb/WPR12LA147.md): Beech 35-C33 · St. George, UT · Accident · No injuries · Limited investigation · Final report · Mar 21, 2012 · N866P · Substantial damage
  > The total loss of engine power due to the loose mixture control arm.
- [NTSB CEN12FA196](https://openairdocs.org/ntsb/CEN12FA196.md): Beech 35 · Glencoe, MN · Accident · 3 fatal · Field investigation · Final report · Mar 21, 2012 · N3871N · Substantial damage
  > The non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.
- [NTSB WPR12LA144](https://openairdocs.org/ntsb/WPR12LA144.md): Boeing 737-7H4 · Laverne, OK · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2012 · N247WN · No damage
  > The airplane’s encounter with severe turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB WPR12LA141](https://openairdocs.org/ntsb/WPR12LA141.md): Grimm RV-9A · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Mar 20, 2012 · N629BJ · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA12LA241](https://openairdocs.org/ntsb/ERA12LA241.md): Cessna 172K · Belfast, ME · Accident · No injuries · Limited investigation · Final report · Mar 20, 2012 · N46492 · Substantial damage
  > The 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…
- [NTSB ERA12WA240](https://openairdocs.org/ntsb/ERA12WA240.md): Cessna 182 · Barrancabermeja, Colombia · Accident · 3 fatal · Foreign investigation · Mar 17, 2012 · HK1441G · Substantial damage
  > On March 17, 2012, about 2145 universal coordinated time (1645 local time), a Cessna 182M, Colombian registration HK1441G, was substantially damaged when it impacted transmission lines, then terrain, about 3 nautical miles south of Aeropuerto Yariguies…
- [NTSB ERA12LA234](https://openairdocs.org/ntsb/ERA12LA234.md): Cessna 172K · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 2012 · N79509 · Substantial damage
  > A total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB ERA12LA231](https://openairdocs.org/ntsb/ERA12LA231.md): Firefly Balloons Firefly 8 · Fitzgerald, GA · Accident · 1 fatal · Limited investigation · Final report · Mar 16, 2012 · N14643 · Substantial damage
  > The pilot's intentional flight into adverse weather. Contributing to the accident was the pilot's failure to obtain a weather briefing and his failure to follow the balloon manufacturer's published emergency procedure for weather deterioration during flight.
- [NTSB WPR12FA139](https://openairdocs.org/ntsb/WPR12FA139.md): Beech B36 · Panoche, CA · Accident · 1 fatal · Field investigation · Final report · Mar 15, 2012 · N364AB · Substantial damage
  > The pilot’s lack of situational awareness regarding the surrounding terrain while descending during dark night conditions, which resulted in controlled flight into terrain.
- [NTSB ERA12LA227](https://openairdocs.org/ntsb/ERA12LA227.md): Emeraude CP-301-A · Niceville, FL · Accident · 2 fatal · Limited investigation · Final report · Mar 15, 2012 · N718PP · Substantial damage
  > The pilots’ inadequate use of carburetor heat, which resulted in carburetor icing and a subsequent loss of engine power.
- [NTSB ERA12LA224](https://openairdocs.org/ntsb/ERA12LA224.md): Cessna T210J · Rabbit Hash, KY · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 2012 · N2275R · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12LA226](https://openairdocs.org/ntsb/ERA12LA226.md): Michael S/Michael K Safari · Middle Valley, TN · Accident · Serious injuries · Limited investigation · Final report · Mar 13, 2012 · N105KM · Substantial damage
  > A partial loss of engine power for reasons that could not be determined due to the postaccident condition of the airframe and engine.
- [NTSB ERA12CA236](https://openairdocs.org/ntsb/ERA12CA236.md): Diamond Aircraft Ind DA 42 · New Smyrna, FL · Accident · No injuries · Data collection · Final report · Mar 12, 2012 · N915ER · Substantial damage
  > An inadvertent encounter with a bird during cruise flight.
- [NTSB WPR12LA128](https://openairdocs.org/ntsb/WPR12LA128.md): Beech 76 · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 2012 · N6697L · Substantial damage
  > A loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.
- [NTSB ERA12LA219](https://openairdocs.org/ntsb/ERA12LA219.md): Cirrus Design SR22 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Mar 9, 2012 · N444VR · Substantial damage
  > The inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…
- [NTSB OPS12WA430](https://openairdocs.org/ntsb/OPS12WA430.md): Gulfstream Aerospace GV SP (G550) · Ontario, Canada · Incident · No injuries · Foreign investigation · Mar 8, 2012 · N128GV · 2 aircraft · No damage
  > N217AL, a private Cessna 750, was en route between San Jose, California (KSJC), and Bedford, Massachusetts (KBED) at FL430. N128GV, a private Gulfstream V, was en route between Bradley/Windsor Locks, Connecticut (KBDL), and San Francisco, California (KSFO),…
- [NTSB ERA12CA218](https://openairdocs.org/ntsb/ERA12CA218.md): Piper PA-31-350 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Mar 7, 2012 · N4083Y · Substantial damage
  > An in-flight collision with birds during cruise flight.
- [NTSB ERA12WA239](https://openairdocs.org/ntsb/ERA12WA239.md): Piper PA28R · Eliseu Martins, Brazil · Accident · 3 fatal · Foreign investigation · Mar 6, 2012 · PT-NKS · Destroyed
  > On March 6, 2012, about 1400 universal coordinated time, a Piper PA-28R-200, Brazilian registration PT-NKS, was destroyed when it impacted terrain, following a loss of control during cruise flight near Eliseu Martins, Brazil. The foreign certificated pilot…
- [NTSB CEN12LA182](https://openairdocs.org/ntsb/CEN12LA182.md): Piper PA-22-150 · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Mar 5, 2012 · N6849B · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA181](https://openairdocs.org/ntsb/CEN12LA181.md): Sikorsky 269C · Staples, TX · Accident · No injuries · Limited investigation · Final report · Mar 5, 2012 · N1099N · Substantial damage
  > The pilot's failure to attain the proper descent rate during autorotation, which resulted in a hard landing. Contributing to the accident were the inflight vibrations and loss of torque pedal response for undetermined reasons.
- [NTSB ERA12WA212](https://openairdocs.org/ntsb/ERA12WA212.md): Cessna 172N · Miranda, Venezuela · Accident · 1 fatal · Foreign investigation · Mar 3, 2012 · YV105E · Destroyed
  > On March 3, 2012, about 1259 universal coordinated time, a Cessna 172N, Venezuelan registration, YV105E, was destroyed when it impacted into terrain while in cruise flight near Municipio Zamora Parroquia Bolivar, Miranda, Venezuela. The pilot was fatally…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=92

## 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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=91

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