# 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 103 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CEN10CA146](https://openairdocs.org/ntsb/CEN10CA146.md): Byler JDT MINI-MAX 1100R · New Paris, IN · Accident · No injuries · Data collection · Final report · Mar 8, 2010 · N184PT · Substantial damage
  > A total loss of engine power in flight due to carburetor icing. Contributing to the accident was the soft field where the airplane nosed over.
- [NTSB ANC10LA020](https://openairdocs.org/ntsb/ANC10LA020.md): Mcdonnell Douglas Helicopter 369E · Delta Junction, AK · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 2010 · N26TC · Substantial damage
  > A total loss of engine power in flight for undetermined reasons.
- [NTSB CEN10LA140](https://openairdocs.org/ntsb/CEN10LA140.md): Beech A36 · Slaton, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 2010 · N2036Y · Substantial damage
  > The loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.
- [NTSB CEN10FA141](https://openairdocs.org/ntsb/CEN10FA141.md): Evektor-Aerotechnik Sportstar Plus · Marysville, OH · Accident · 2 fatal · Field investigation · Final report · Mar 5, 2010 · N930LA · Substantial damage
  > The pilot's improper decision to initiate and continue a flight into instrument meteorological conditions that led to spatial disorientation and a loss of control during cruise flight.
- [NTSB ERA10LA159](https://openairdocs.org/ntsb/ERA10LA159.md): Cessna P210N · Arcadia, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 2010 · N4797K · Substantial damage
  > The total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.
- [NTSB DCA12WA015](https://openairdocs.org/ntsb/DCA12WA015.md): Boeing 737 · Brussels, Belgium · Incident · No injuries · Foreign investigation · Mar 1, 2010 · EIDYI · Minor damage
  > The Irish Air Accident Investigation Unit (AAIU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on March 1, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of…
- [NTSB CEN10LA131](https://openairdocs.org/ntsb/CEN10LA131.md): Lacour Long-EZE SR7-1 · Falfurrias, TX · Accident · No injuries · Limited investigation · Final report · Mar 1, 2010 · N97EZ · Substantial damage
  > A total loss of engine power due to a failure of the crankshaft behind the No. 3 connecting rod journal for undetermined reasons.
- [NTSB WPR10LA149](https://openairdocs.org/ntsb/WPR10LA149.md): Schafer Starduster SA-300 · North Bend, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 2010 · N105NL · Substantial damage
  > The complete loss of engine power during cruise for undetermined reasons.
- [NTSB CEN10WA134](https://openairdocs.org/ntsb/CEN10WA134.md): Cessna 150 · Waldzell, Austria · Accident · 2 fatal · Foreign investigation · Feb 28, 2010 · OE-CFT · Substantial damage
  > This accident is under the jurisdiction and control of the Austrian government.
- [NTSB WPR10CA144](https://openairdocs.org/ntsb/WPR10CA144.md): Cessna 172 · Sparks, NV · Accident · No injuries · Data collection · Final report · Feb 22, 2010 · N7499A · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's failure to select the correct fuel selector position.
- [NTSB ERA10LA151](https://openairdocs.org/ntsb/ERA10LA151.md): Cotter Stits Playmate · Williston, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 2010 · N816 · Substantial damage
  > A loss of engine power during approach due to fuel exhaustion as a result of the pilot's fuel mismanagement.
- [NTSB ERA10IA147](https://openairdocs.org/ntsb/ERA10IA147.md): Piper PA-46-310P · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Feb 21, 2010 · N43368 · Minor damage
  > A loss of engine power due to the mechanic’s failure to properly secure the fuel control unit fuel lines after replacement of the starter adapter.
- [NTSB WPR10FA142](https://openairdocs.org/ntsb/WPR10FA142.md): Piper PA-32R-301T · Groveland, CA · Accident · 2 fatal · Field investigation · Final report · Feb 20, 2010 · N4175A · Substantial damage
  > The pilot's continued flight into night instrument meteorological conditions during the landing approach, which resulted in an in-flight loss of aircraft control due to spatial disorientation.
- [NTSB DCA10CA032](https://openairdocs.org/ntsb/DCA10CA032.md): Boeing 747 · Anchorage, AK · Accident · Serious injuries · Data collection · Final report · Feb 19, 2010 · N173UA · Minor damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB WPR10LA138](https://openairdocs.org/ntsb/WPR10LA138.md): Robinson Helicopter R22 Beta · Parlier, CA · Accident · No injuries · Limited investigation · Final report · Feb 17, 2010 · N313DA · Substantial damage
  > The pilot inadvertently entered a low-G condition during cruise flight, which resulted in a momentary loss of control of the helicopter and mast bumping.
- [NTSB DCA10WA095](https://openairdocs.org/ntsb/DCA10WA095.md): Boeing 757 · Las Palmas, Spain · Incident · No injuries · Foreign investigation · Feb 17, 2010 · G-BYAI · No damage
  > On February 17, 2010, at 1555 UTC, a Thompson Airways Boeing 757 experienced pilot and first officer airspeed indicator anomalies during climbout from Gran Canaria Airport (LPA), Las Palmas, Canary Islands, Spain. The event occurred during a period of…
- [NTSB WPR10FA133](https://openairdocs.org/ntsb/WPR10FA133.md): Eurocopter EC135 · Cave Creek, AZ · Accident · 5 fatal · Field investigation · Final report · Feb 14, 2010 · N127TS · Substantial damage
  > The sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…
- [NTSB CEN10LA123](https://openairdocs.org/ntsb/CEN10LA123.md): Cessna 172N · Genoa City, WI · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2010 · N24CV · Substantial damage
  > A total loss of engine power due to the failure of the bolts that held in place the connecting rods to the engine's No. 3 and No. 4 cylinders as a result of the engine overhaul facility's improper installation of the bolts during a recent overhaul.
- [NTSB CEN10LA204](https://openairdocs.org/ntsb/CEN10LA204.md): Cessna 680 · Eagle, CO · Accident · No injuries · Limited investigation · Final report · Feb 13, 2010 · N606CS · Substantial damage
  > The airplane’s encounter with localized severe to extreme mountain wave turbulence which resulted in substantial damage to both wings.
- [NTSB ANC10TA017](https://openairdocs.org/ntsb/ANC10TA017.md): Piper PA-18-150 · King Cove, AK · Accident · No injuries · Final report · Feb 11, 2010 · N278Z · Substantial damage
  > A total loss of engine power due to the pilot's failure to use carburetor heat in conditions conducive to carburetor ice.
- [NTSB WPR10CA129](https://openairdocs.org/ntsb/WPR10CA129.md): Maule M-5-235C · Kelton, UT · Accident · No injuries · Data collection · Final report · Feb 6, 2010 · N9227E · Substantial damage
  > The non-instrument-rated pilot's decision to take off and fly into marginal weather conditions.
- [NTSB CEN10FA115](https://openairdocs.org/ntsb/CEN10FA115.md): Piper PA-25-235 · Boulder, CO · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2010 · N8718L · 3 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other resulting in a midair collision. Contributing to the accident was the lack of perceived visual relative motion of the Piper and the Cirrus to the pilot of each airplane, the terrain background, and the…
- [NTSB WPR10LA128](https://openairdocs.org/ntsb/WPR10LA128.md): Piper PA-32R-301T · Dolan Springs, AZ · Accident · No injuries · Limited investigation · Final report · Feb 4, 2010 · N1060X · Substantial damage
  > The fuel flow divider inlet line nut coming loose during cruise flight, resulting in a fuel leak and in-flight fire. The root cause of the loose B-nut fitting could not be determined. Contributing to the accident was the pilot's decision to fly the airplane…
- [NTSB ERA10WA133](https://openairdocs.org/ntsb/ERA10WA133.md): Robinson Helicopter R44 II · Restauracion, Dominican Republic, Dominican Republic · Accident · 2 fatal · Foreign investigation · Feb 4, 2010 · N7535F · Destroyed
  > On February 4, 2010, about 1940 Atlantic standard time, a Robinson R44II helicopter, N7535F, impacted the side of Mount Jina Mocha, in the city of Restauracion, Dominican Republic, at night, while en route from Port Au Prince, Haiti to Cibao International…
- [NTSB WPR10LA126](https://openairdocs.org/ntsb/WPR10LA126.md): Arrow Falcon Exporters OH-58A · Escalon, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 2010 · N9286U · Substantial damage
  > A loss of engine power during cruise flight due to the fatigue failure of the pneumatic fuel-to-governor control line. Also causal was the inadequate installation of the pneumatic line by maintenance personnel, and the pilot’s decision to continue flight with…
- [NTSB ERA10LA127](https://openairdocs.org/ntsb/ERA10LA127.md): Cessna 150G · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Feb 1, 2010 · N3995J · Substantial damage
  > A loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.
- [NTSB WPR10LA123](https://openairdocs.org/ntsb/WPR10LA123.md): Cessna 172 · Pahrump, NV · Accident · No injuries · Limited investigation · Final report · Jan 30, 2010 · N8959B · Substantial damage
  > Fuel starvation as a result of the improper installation of the carburetor float valve by unknown personnel.
- [NTSB ERA11WA269](https://openairdocs.org/ntsb/ERA11WA269.md): Embraer EMB-202 · Guarau, Brazil · Incident · No injuries · Foreign investigation · Jan 28, 2010 · PT-UPW · No damage
  > On January 28, 2010, about 1030 coordinated universal time, an Embraer EMB-202, Brazilian registration PT-UPW, had a reported loss of power during cruise and landed in a soybean field near Guarau, Santa Catarina, Brazil. The pilot was not injured And the…
- [NTSB CEN10WA309](https://openairdocs.org/ntsb/CEN10WA309.md): Robinson Helicopter R44 · Horten, Norway, Norway · Accident · 4 fatal · Foreign investigation · Jan 27, 2010 · LN-OCV · Substantial damage
  > On January 27, 2010, at 1323 coordinated universal time (UTC), a Robinson Helicopter Company model R44, s/n 0024, Norwegian registration LN-OCV, was substantially damaged when it impacted Oslofjord, near Horten, Norway. The pilot and 3 passengers were fatally…
- [NTSB WPR10LA119](https://openairdocs.org/ntsb/WPR10LA119.md): Czech Aircraft Works Spol Sro Sportcruiser · La Quinta, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2010 · N243SC · Substantial damage
  > A loss of engine power during cruise flight due to water contamination in the fuel.
- [NTSB CEN10FA108](https://openairdocs.org/ntsb/CEN10FA108.md): Smith Aerostar 601P · Sugar Grove, IL · Accident · 2 fatal · Field investigation · Final report · Jan 24, 2010 · N222AQ · Destroyed
  > The pilot's spatial disorientation and subsequent failure to maintain airplane control.
- [NTSB WPR10LA118](https://openairdocs.org/ntsb/WPR10LA118.md): Cessna 182C · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Jan 23, 2010 · N8948T · Substantial damage
  > A total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.
- [NTSB ERA10WA340](https://openairdocs.org/ntsb/ERA10WA340.md): Robinson R44 · San Felipe, Chile · Accident · Minor injuries · Foreign investigation · Jan 21, 2010 · CC-PSZ · Substantial damage
  > On January 21, 2010, at 2210 universal coordinated time, a Robinson R44 helicopter, Chilean registration CC-PSZ, experienced a loss of engine power while in cruise flight, and was substantially damaged during a subsequent forced landing, in San Felipe, Chile.…
- [NTSB WPR10LA115](https://openairdocs.org/ntsb/WPR10LA115.md): Cessna 172M · Joshua Tree, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 18, 2010 · N13073 · Substantial damage
  > The certified flight instructor's decision to continue visual flight into deteriorating weather, which resulted in his inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain clearance with terrain.
- [NTSB WPR10GA113](https://openairdocs.org/ntsb/WPR10GA113.md): Cessna 182R · Corvallis, OR · Accident · 2 fatal · Final report · Jan 18, 2010 · N702 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while operating into a known area of mountain obscuration due to low clouds, precipitation, and mist.
- [NTSB ERA10LA118](https://openairdocs.org/ntsb/ERA10LA118.md): Eurocopter AS 350 B2 · New York, NY · Accident · No injuries · Limited investigation · Final report · Jan 18, 2010 · N696BH · Substantial damage
  > The failure of maintenance personnel to properly secure one tail rotor pitch change link to its respective tail rotor blade resulting in an in-flight separation of the link from the blade. Contributing to the accident was the lack of an adequate…
- [NTSB ERA10FA115](https://openairdocs.org/ntsb/ERA10FA115.md): Beech B-60 · Madison, AL · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2010 · N810JA · Substantial damage
  > The pilot's failure to divert to the nearest suitable airport following a total loss of power in the right engine during cruise flight. Contributing to the accident was the total loss of power in the right engine due to separation of its No. 2 cylinder as a…
- [NTSB ERA10LA111](https://openairdocs.org/ntsb/ERA10LA111.md): Stinson 108 · Bayport, NY · Accident · No injuries · Limited investigation · Final report · Jan 9, 2010 · N97223 · Substantial damage
  > A total loss of engine power during cruise flight due to fuel contamination.
- [NTSB ERA10CA109](https://openairdocs.org/ntsb/ERA10CA109.md): Schweizer 269C-1 · Grantsville, MD · Accident · Serious injuries · Data collection · Final report · Jan 6, 2010 · N3275M · Substantial damage
  > The pilot's loss of aircraft control after encountering turbulence over a mountain range. Contributing to the accident was the pilot's failure to obtain an Airmet for turbulence along the route of flight prior to departure and while enroute.
- [NTSB CEN10CA092](https://openairdocs.org/ntsb/CEN10CA092.md): Cessna 150L · Brownstown, IL · Accident · Minor injuries · Data collection · Final report · Jan 5, 2010 · N10401 · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.
- [NTSB ERA10LA105](https://openairdocs.org/ntsb/ERA10LA105.md): Cessna 172S · Greenbush, ME · Accident · 1 fatal · Limited investigation · Final report · Jan 4, 2010 · N5118J · Substantial damage
  > The pilot's improper decision to attempt a transoceanic flight in turbulent, icing conditions, with an overweight airplane that was not approved for moderate turbulence and not equipped with deicing systems. Contributing to the accident was the pilot's…
- [NTSB CEN10CA087](https://openairdocs.org/ntsb/CEN10CA087.md): Maule M-4-220C · Pearsall, TX · Accident · No injuries · Data collection · Final report · Jan 2, 2010 · N2028U · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.
- [NTSB WPR10RA093](https://openairdocs.org/ntsb/WPR10RA093.md): Cessna 185 · Baindoang, PNG, Papua New Guinea · Accident · 6 fatal · Class 5 · Foreign · Dec 30, 2009 · P2-MJL · Destroyed
  > On December 30, 2009, about 0618 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 185E, P2-MJL, made a forced emergency landing on mountainous terrain following a loss of oil pressure, about 1 nautical mile southwest of a remote…
- [NTSB CEN10IA084](https://openairdocs.org/ntsb/CEN10IA084.md): ATR ATR72 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Dec 26, 2009 · N494AE · Minor damage
  > A fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…
- [NTSB ERA10LA102](https://openairdocs.org/ntsb/ERA10LA102.md): Davis Michael J Longez · Dexter, KY · Accident · 1 fatal · Limited investigation · Final report · Dec 25, 2009 · N499CM · Destroyed
  > The loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.
- [NTSB ERA10FA099](https://openairdocs.org/ntsb/ERA10FA099.md): Piper PA-28-140 · Heflin, AL · Accident · 1 fatal · Field investigation · Final report · Dec 25, 2009 · N1277T · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…
- [NTSB CEN10CA081](https://openairdocs.org/ntsb/CEN10CA081.md): Cessna 182P · Bowie, TX · Accident · Minor injuries · Data collection · Final report · Dec 25, 2009 · N21177 · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.
- [NTSB WPR10CA089](https://openairdocs.org/ntsb/WPR10CA089.md): Cessna 172M · Albion, ID · Accident · No injuries · Data collection · Final report · Dec 24, 2009 · N1883V · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.
- [NTSB ERA10LA101](https://openairdocs.org/ntsb/ERA10LA101.md): Bellanca 7GCBC · St. Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 2009 · N8634V · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ERA10LA100](https://openairdocs.org/ntsb/ERA10LA100.md): Fpna A-22 Valor · Hunting Island, SC · Accident · No injuries · Limited investigation · Final report · Dec 23, 2009 · N721FP · Substantial damage
  > Maintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.

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

## 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=103

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