# NTSB investigations: Initial climb

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 44 of 412 · 20,559 cases

## Cases, newest first

- [NTSB CEN12LA244](https://openairdocs.org/ntsb/CEN12LA244.md): T Bird Golden Circle Air II · Clara City, MN · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 2012 · N5654N · Substantial damage
  > The airplane's loss of engine power for reasons that could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have precluded normal operation.
- [NTSB ERA12CA281](https://openairdocs.org/ntsb/ERA12CA281.md): Piper J3C-65 · Plantation Key, FL · Accident · No injuries · Data collection · Final report · Apr 13, 2012 · N75487 · Substantial damage
  > The pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.
- [NTSB ERA12FA271](https://openairdocs.org/ntsb/ERA12FA271.md): Wejebe Jose CA8 -SF · Everglades City, FL · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2012 · N548SF · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB WPR12LA152](https://openairdocs.org/ntsb/WPR12LA152.md): Nelson Rans S-12 · Mesa, AZ · Accident · 2 fatal · Limited investigation · Final report · Apr 3, 2012 · N586BN · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.
- [NTSB ERA12FA265](https://openairdocs.org/ntsb/ERA12FA265.md): Sapp Larry E Seawind 3000 · Deland, FL · Accident · Serious injuries · Field investigation · Final report · Apr 2, 2012 · N514KT · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the damage and postimpact fire precluded thorough examination of the engine and its systems.
- [NTSB ERA12LA264](https://openairdocs.org/ntsb/ERA12LA264.md): Powrachute Airwolf 912ULS · Plant City, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 2012 · N415BA · Minor damage
  > The flight instructor’s failure to ensure an obstruction-free takeoff path prior to initiating the takeoff and his inadequate preflight inspection of the powered parachute’s flight controls, which resulted in a collision with trees during the takeoff.
- [NTSB ERA12FA262](https://openairdocs.org/ntsb/ERA12FA262.md): Beech 58 · Calhoun, KY · Accident · 1 fatal · Field investigation · Final report · Apr 1, 2012 · N9448Q · Substantial damage
  > The failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…
- [NTSB WPR12LA149](https://openairdocs.org/ntsb/WPR12LA149.md): Powrachute Sky Rascal · Indio, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 2012 · UNREG · Substantial damage
  > The operation of an airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot's failure to maintain clearance from powerlines during initial climb in gusty wind conditions.
- [NTSB ERA12LA260](https://openairdocs.org/ntsb/ERA12LA260.md): Hughes 369D · McCormick, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 2012 · N868W · Substantial damage
  > The pilot's decision to use automotive fuel instead of the approved alternate fuel, which resulted in a total loss of engine power.
- [NTSB ERA12WA255](https://openairdocs.org/ntsb/ERA12WA255.md): Piper PA-32R-300 · Treasure Cay, Bahamas · Accident · 4 fatal · Foreign investigation · Mar 25, 2012 · N8415C · Substantial damage
  > On March 25, 2012, at 1830 UTC, a Piper PA-32R-300, N8415C, was substantially damaged when it crashed shortly after takeoff from Treasure Cay International Airport (MYAT), Abaco, Bahamas. The two certificated private pilots and two passengers were fatally…
- [NTSB CEN12LA203](https://openairdocs.org/ntsb/CEN12LA203.md): Enbody Frank GY 201 Minicab · Granite Shoals, TX · Accident · 1 fatal · Limited investigation · Final report · Mar 24, 2012 · N416FC · Substantial damage
  > A loss of engine power due to fuel starvation as a result of a contaminated carburetor fuel screen. Contributing to the accident was the pilot's impairment from medications that degraded his decision-making and the pilot's improper maintenance of the airplane.
- [NTSB WPR12LA143](https://openairdocs.org/ntsb/WPR12LA143.md): Reich Glastar · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Mar 22, 2012 · N617G · Substantial damage
  > The failure of a propeller blade at the hub due to fatigue cracking.
- [NTSB CEN12LA239](https://openairdocs.org/ntsb/CEN12LA239.md): Gerner Evans WE-1 · Kimball, NE · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 2012 · N5936 · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident examination of the airplane and engine was not performed.
- [NTSB ERA12LA230](https://openairdocs.org/ntsb/ERA12LA230.md): Sadler Terry A Merlin · Otisfield, ME · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 2012 · N6113Y · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was his lack of experience in the airplane make and model.
- [NTSB ERA12LA229](https://openairdocs.org/ntsb/ERA12LA229.md): Flight Design Ctsw · Venice, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 2012 · N379CT · Substantial damage
  > A total loss of engine power due to a loss of fuel pressure. The cause for the loss of fuel pressure could not be determined during postaccident testing.
- [NTSB ERA12WA202](https://openairdocs.org/ntsb/ERA12WA202.md): Cessna 208 · Manaus, Brazil · Accident · 1 fatal · Foreign investigation · Feb 28, 2012 · PT-PTB · Substantial damage
  > On February 28, 2012, about 1020 universal coordinated time, a Cessna 208B, Brazilian registration PT-PTB, operated by Cleiton Taxi Aereo Ltda., was substantially damaged when it impacted a lamppost and terrain, during the initial climb after takeoff from…
- [NTSB CEN12FA170](https://openairdocs.org/ntsb/CEN12FA170.md): Mooney M20E · San Antonio, TX · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2012 · N9224M · Substantial damage
  > The pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…
- [NTSB ERA12FA193](https://openairdocs.org/ntsb/ERA12FA193.md): Cessna 172S · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Feb 24, 2012 · N53589 · Substantial damage
  > The non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.
- [NTSB WPR12LA110](https://openairdocs.org/ntsb/WPR12LA110.md): Beech C23 · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Feb 18, 2012 · N5205M · Substantial damage
  > The pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB WPR12LA108](https://openairdocs.org/ntsb/WPR12LA108.md): Mooney M20J · Lewiston, CA · Accident · No injuries · Limited investigation · Final report · Feb 17, 2012 · N367MR · Substantial damage
  > A loss of engine power due to oil starvation as a result of improper maintenance.
- [NTSB ERA12WA238](https://openairdocs.org/ntsb/ERA12WA238.md): Beech 95B55 · Cameta, Brazil · Accident · 4 fatal · Foreign investigation · Feb 16, 2012 · PT-LOU · Destroyed
  > On February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…
- [NTSB ENG12IA010](https://openairdocs.org/ntsb/ENG12IA010.md): Boeing 767 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Feb 8, 2012 · N360AA · No damage
  > The failure of the American Airlines aviation maintenance technicians to properly reassemble the two-piece bracket and spray shield on the integrated drive generator fuel-oil heat exchanger that caused a fuel leak that sprayed out and ignited on hot engine…
- [NTSB WPR12LA092](https://openairdocs.org/ntsb/WPR12LA092.md): Piper PA-28R-201T · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 2012 · N38906 · Substantial damage
  > The partial loss of engine power due to magneto malfunction. Contributing to the accident was the lack of adherence to the manufacturer’s recommended magneto overhaul schedule.
- [NTSB WPR12FA091](https://openairdocs.org/ntsb/WPR12FA091.md): Cessna T206H · Show Low, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 4, 2012 · N445GH · Substantial damage
  > The pilot’s encounter with low clouds/low visibility conditions during the initial climb, which resulted in spatial disorientation and loss of airplane control.
- [NTSB CEN12LA149](https://openairdocs.org/ntsb/CEN12LA149.md): Pipistrel Virus 912 · Ray, MI · Accident · 1 fatal · Limited investigation · Final report · Feb 4, 2012 · N325MZ · Substantial damage
  > A loss of engine power due to fuel starvation for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA089](https://openairdocs.org/ntsb/WPR12FA089.md): Garza Lancair IV-TP · Boise, ID · Accident · 1 fatal · Field investigation · Final report · Feb 3, 2012 · N321LC · Destroyed
  > A loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…
- [NTSB CEN12LA146](https://openairdocs.org/ntsb/CEN12LA146.md): Piper PA-22-135 · Sheridan, AR · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 2012 · N2677A · Substantial damage
  > The passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.
- [NTSB ERA12LA164](https://openairdocs.org/ntsb/ERA12LA164.md): Cessna T210M · Clearwater, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 2012 · N761HW · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…
- [NTSB CEN12LA192](https://openairdocs.org/ntsb/CEN12LA192.md): Aero Commander 100 · Seguin, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 2012 · N5551M · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ERA12FA151](https://openairdocs.org/ntsb/ERA12FA151.md): Cessna 150G · Quincy, FL · Accident · 1 fatal · Field investigation · Final report · Jan 23, 2012 · N73JK · Substantial damage
  > The non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…
- [NTSB ERA12FA149](https://openairdocs.org/ntsb/ERA12FA149.md): Aero Vodochody L39C · Rainbow City, AL · Accident · 1 fatal · Field investigation · Final report · Jan 21, 2012 · N16RZ · Substantial damage
  > An in-flight loss of control in instrument meteorological conditions.
- [NTSB ERA12LA150](https://openairdocs.org/ntsb/ERA12LA150.md): M-Squared Breese 2 · Bayou La Batre, AL · Accident · No injuries · Limited investigation · Final report · Jan 19, 2012 · N582MS · Substantial damage
  > The pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.
- [NTSB ERA12FA146](https://openairdocs.org/ntsb/ERA12FA146.md): Aerostar PA-60-601P · Philadelphia, MS · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2012 · N700PS · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…
- [NTSB ERA12FA143](https://openairdocs.org/ntsb/ERA12FA143.md): Cessna 150G · Fitchburg, MA · Accident · Serious injuries · Field investigation · Final report · Jan 11, 2012 · N4041J · Substantial damage
  > A partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.
- [NTSB ERA12LA141](https://openairdocs.org/ntsb/ERA12LA141.md): Bowers Fly Baby 1-A · Jefferson, GA · Accident · 1 fatal · Limited investigation · Final report · Jan 8, 2012 · N4626 · Destroyed
  > The pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…
- [NTSB ERA12LA131](https://openairdocs.org/ntsb/ERA12LA131.md): Haney John F B Seastar XP · Willimantic, CT · Accident · No injuries · Limited investigation · Final report · Jan 1, 2012 · N667JH · Substantial damage
  > A partial loss of engine power due to carburetor icing. Contributing to the accident was the lack of an installed manufacturer-recommended carburetor heat system.
- [NTSB ERA12FA130](https://openairdocs.org/ntsb/ERA12FA130.md): Piper PA-25-235 · Jacksonville, FL · Accident · 1 fatal · Field investigation · Final report · Dec 31, 2011 · N7408Z · Substantial damage
  > The pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.
- [NTSB ERA12FA127](https://openairdocs.org/ntsb/ERA12FA127.md): Cessna 650 · Ft. Lauderdale, FL · Accident · No injuries · Field investigation · Final report · Dec 28, 2011 · N877G · Substantial damage
  > The crew's failure to use proper emergency procedures during an uncommanded right roll after takeoff, which led to a forced landing with a quartering tailwind. Contributing to the accident was a faulty right roll spoiler actuator, which allowed the right roll…
- [NTSB ERA12CA125](https://openairdocs.org/ntsb/ERA12CA125.md): Cessna 150H · Knoxville, TN · Accident · Serious injuries · Data collection · Final report · Dec 26, 2011 · N22565 · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12CA124](https://openairdocs.org/ntsb/ERA12CA124.md): Chapel Robert B Aerial · Simsbury, CT · Accident · No injuries · Data collection · Final report · Dec 26, 2011 · N435AB · Substantial damage
  > The pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.
- [NTSB ANC12FA014](https://openairdocs.org/ntsb/ANC12FA014.md): Cessna U206G · Nanwalek, AK · Accident · Minor injuries · Field investigation · Final report · Dec 15, 2011 · N252AL · Substantial damage
  > The pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…
- [NTSB ERA12LA106](https://openairdocs.org/ntsb/ERA12LA106.md): Cessna 152 · Venice, FL · Accident · No injuries · Limited investigation · Final report · Dec 9, 2011 · N471TC · Substantial damage
  > A loss of engine power during takeoff for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12LA103](https://openairdocs.org/ntsb/CEN12LA103.md): Beech C23 · Watertown, SD · Accident · No injuries · Limited investigation · Final report · Dec 9, 2011 · N6717K · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB WPR12LA051](https://openairdocs.org/ntsb/WPR12LA051.md): Piper PA-44-180 · Seattle, WA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 2011 · N2163N · Substantial damage
  > The flight instructor’s failure to maintain airplane control during a go-around.
- [NTSB WPR12LA048](https://openairdocs.org/ntsb/WPR12LA048.md): Piper PA-32RT-300T · Hailey, ID · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2011 · N36824 · Substantial damage
  > The pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.
- [NTSB ERA12WA086](https://openairdocs.org/ntsb/ERA12WA086.md): Bell 212 · Quito, Ecuador · Accident · Serious injuries · Foreign investigation · Nov 25, 2011 · HC-CLH · Substantial damage
  > On November 25, 2011, about 1640 coordinated universal time (1140 local time), a Bell 212, Ecuadorian registration HC-CLH, operated by Aeromaster Airways, S.A., was substantially damaged when it impacted steep terrain next to the company's helipad in Quito,…
- [NTSB ERA12CA088](https://openairdocs.org/ntsb/ERA12CA088.md): Anatra Bart T Vans RV-7A · Quinton, VA · Accident · No injuries · Data collection · Final report · Nov 25, 2011 · N816BA · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.
- [NTSB CEN12LA076](https://openairdocs.org/ntsb/CEN12LA076.md): Cirrus Design SR20 · New Orleans, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2011 · N211CD · Substantial damage
  > A loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.
- [NTSB CEN12CA075](https://openairdocs.org/ntsb/CEN12CA075.md): Globe GC-1B · Denver, CO · Accident · No injuries · Data collection · Final report · Nov 19, 2011 · N80775 · Substantial damage
  > A loss of engine power due to fuel starvation as a result of a loose fuel line fitting.
- [NTSB ERA12WA073](https://openairdocs.org/ntsb/ERA12WA073.md): Cessna 150 · Santa Rosa, Ecuador · Accident · 2 fatal · Foreign investigation · Nov 14, 2011 · HC-BJA · Substantial damage
  > On November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=45

## 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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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