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

## Cases, newest first

- [NTSB ERA12IA097](https://openairdocs.org/ntsb/ERA12IA097.md): Cessna 560XL · Ocoee, FL · Incident · No injuries · Incident investigation · Final report · Dec 2, 2011 · N576CS · No damage
  > Water contamination in the pitch trim actuators.
- [NTSB CEN12IA096](https://openairdocs.org/ntsb/CEN12IA096.md): Bell Helicopter Textron Canada 407 · Gulf Of Mexico · Incident · No injuries · Incident investigation · Final report · Dec 1, 2011 · N435PH · No damage
  > The failure of the compressor section No. 2 bearing due to false brinnelling and fatigue.
- [NTSB CEN12FA088](https://openairdocs.org/ntsb/CEN12FA088.md): Piper PA-31 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2011 · N6485L · Minor damage
  > The pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.
- [NTSB ANC12FA009](https://openairdocs.org/ntsb/ANC12FA009.md): Cessna 207 · Chuathbaluk, AK · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2011 · N1673U · Substantial damage
  > The pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.
- [NTSB ERA12LA087](https://openairdocs.org/ntsb/ERA12LA087.md): Smith Miniplane DSA-4 · Hernando, FL · Accident · No injuries · Limited investigation · Final report · Nov 27, 2011 · N1321 · Substantial damage
  > The pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.
- [NTSB ERA12WA105](https://openairdocs.org/ntsb/ERA12WA105.md): Cirrus SR20 · Minas Gerias, Brazil · Accident · 2 fatal · Foreign investigation · Nov 26, 2011 · PR-LJL · Substantial damage
  > On November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…
- [NTSB ERA12FA084](https://openairdocs.org/ntsb/ERA12FA084.md): Cessna 177RG · Tallapoosa, GA · Accident · 3 fatal · Field investigation · Final report · Nov 26, 2011 · N5AW · Substantial damage
  > The failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.
- [NTSB CEN12FA083](https://openairdocs.org/ntsb/CEN12FA083.md): Cirrus Design SR20 · Crystal Lake, IL · Accident · 4 fatal · Field investigation · Final report · Nov 26, 2011 · N223CD · Substantial damage
  > The noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.
- [NTSB WPR12MA046](https://openairdocs.org/ntsb/WPR12MA046.md): Rockwell 690 · Apache Junction, AZ · Accident · 6 fatal · Major investigation · Final report · Nov 24, 2011 · N690SM · Destroyed
  > The pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…
- [NTSB ERA12LA085](https://openairdocs.org/ntsb/ERA12LA085.md): Piper PA 46-350P · Caribbean Sea, A1 · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2011 · N534P · Substantial damage
  > The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…
- [NTSB CEN12FA080](https://openairdocs.org/ntsb/CEN12FA080.md): Diamond Aircraft Ind DA 20-C1 · Bern, WI · Accident · 1 fatal · Field investigation · Final report · Nov 24, 2011 · N203MK · Substantial damage
  > The non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.
- [NTSB ANC12CA010](https://openairdocs.org/ntsb/ANC12CA010.md): Cessna A185F · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Nov 23, 2011 · N121EE · Substantial damage
  > A broken wheel/ski clevis pin, which allowed the ski to pivot upward and strike the right wing lift strut.
- [NTSB ERA12WA102](https://openairdocs.org/ntsb/ERA12WA102.md): Cessna 210 · Alto Alegre, Brazil · Accident · 1 fatal · Foreign investigation · Nov 22, 2011 · PT-IOT · Substantial damage
  > On November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…
- [NTSB ERA12FA074](https://openairdocs.org/ntsb/ERA12FA074.md): Beech 95-C55 · Ulysses, PA · Accident · Serious injuries · Field investigation · Final report · Nov 17, 2011 · N54552 · Substantial damage
  > The total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…
- [NTSB CEN12FA072](https://openairdocs.org/ntsb/CEN12FA072.md): Piper PA-28-180 · Perryville, AR · Accident · 4 fatal · Field investigation · Final report · Nov 17, 2011 · N7746W · Substantial damage
  > The pilot's loss of control in flight.
- [NTSB WPR12LA039](https://openairdocs.org/ntsb/WPR12LA039.md): Williams Helicopter UH-1H · Grand Canyon, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2011 · N502AW · Substantial damage
  > The loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.
- [NTSB CEN12LA074](https://openairdocs.org/ntsb/CEN12LA074.md): Beech S35 · Elkhart Lake, WI · Accident · No injuries · Limited investigation · Final report · Nov 15, 2011 · N5858S · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA060](https://openairdocs.org/ntsb/CEN12LA060.md): Cessna 180 · Eau Claire, WI · Accident · No injuries · Limited investigation · Final report · Nov 12, 2011 · N3606C · Substantial damage
  > The pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.
- [NTSB CEN12CA079](https://openairdocs.org/ntsb/CEN12CA079.md): Beech 95-B55 (T42A) · College Station, TX · Accident · Minor injuries · Data collection · Final report · Nov 10, 2011 · N8188R · Substantial damage
  > The total loss of engine power from both engines, which resulted from fuel exhaustion due to the pilot’s inadequate pre-flight preparation.
- [NTSB WPR12FA031](https://openairdocs.org/ntsb/WPR12FA031.md): Cessna 182Q · Lake Havasu City, AZ · Accident · 3 fatal · Field investigation · Final report · Nov 7, 2011 · N4701N · Substantial damage
  > The pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.
- [NTSB ERA12CA059](https://openairdocs.org/ntsb/ERA12CA059.md): Beech F33A · Chesterfield, VA · Accident · Minor injuries · Data collection · Final report · Nov 2, 2011 · N833 · Substantial damage
  > A total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.
- [NTSB ERA12FA057](https://openairdocs.org/ntsb/ERA12FA057.md): Eckenrode Carl J Vans RV-6 · Taylorsville, GA · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2011 · N262MA · Substantial damage
  > The airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12IA050](https://openairdocs.org/ntsb/CEN12IA050.md): Nusbaum Vaquero · Hebron, IL · Incident · No injuries · Incident investigation · Final report · Nov 1, 2011 · N30CY · No damage
  > The pilot’s operation of the airplane with known medical conditions and his subsequent heart attack during the flight.
- [NTSB CEN12CA051](https://openairdocs.org/ntsb/CEN12CA051.md): Downer Bellanca 14-19-2 · Borger, TX · Accident · Minor injuries · Data collection · Final report · Nov 1, 2011 · N711W · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.
- [NTSB ERA12CA055](https://openairdocs.org/ntsb/ERA12CA055.md): Tacchi Torello F Vans Aircraft RV10 · Folkston, GA · Accident · No injuries · Data collection · Final report · Oct 30, 2011 · N968TP · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC12FA006](https://openairdocs.org/ntsb/ANC12FA006.md): Eurocopter AS 350 B2 · Iliamna, AK · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2011 · N165EH · Destroyed
  > The pilot's loss of control due to sudden medical impairment or incapacitation.
- [NTSB WPR12LA023](https://openairdocs.org/ntsb/WPR12LA023.md): Cessna 185 · Prineville, OR · Accident · No injuries · Limited investigation · Final report · Oct 28, 2011 · N520YH · Substantial damage
  > A total loss of engine power due to fuel starvation, which resulted from the pilot inadvertently leaving the fuel selector set to the left tank. Contributing to the accident was the pilot’s deviation from his normal habit pattern and his failure to refer to…
- [NTSB DCA12WA010](https://openairdocs.org/ntsb/DCA12WA010.md): Boeing 777 - 200 · Nani, Kenya · Accident · No injuries · Foreign investigation · Oct 28, 2011 · A7-BBD · No damage
  > On October 28, 2011 about 1544 hours UTC, a Boeing 777-200LR, registration number A7-BBD, operated by Qatar Airways, encountered inflight turbulence, during cruise flight near Nani, Kenya. A cabin crew member received serious injuries. The flight originated…
- [NTSB WPR12FA021](https://openairdocs.org/ntsb/WPR12FA021.md): Cessna 182R · Lexington, OR · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2011 · N6545E · Substantial damage
  > The pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.
- [NTSB WPR12FA020](https://openairdocs.org/ntsb/WPR12FA020.md): Piper PA-44-180 · St. Paul, OR · Accident · 1 fatal · Field investigation · Final report · Oct 25, 2011 · N3062H · 2 aircraft · Substantial damage
  > The pilot was unable to see the other aircraft to avoid a collision.
- [NTSB CEN12CA035](https://openairdocs.org/ntsb/CEN12CA035.md): Houts Avid Mark IV · Hibbing, MN · Accident · Minor injuries · Data collection · Final report · Oct 21, 2011 · N43280 · Substantial damage
  > The improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.
- [NTSB WPR12WA186](https://openairdocs.org/ntsb/WPR12WA186.md): Piper PA-34-220T · Karachi, Pakistan · Accident · No injuries · Foreign investigation · Oct 20, 2011 · AP_BDK · Substantial damage
  > On October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…
- [NTSB ERA12CA044](https://openairdocs.org/ntsb/ERA12CA044.md): Boeing 767-2B7 · New York, NY · Accident · Serious injuries · Data collection · Final report · Oct 20, 2011 · N253AY · No damage
  > The passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.
- [NTSB ERA12LA033](https://openairdocs.org/ntsb/ERA12LA033.md): Cessna R172K · Williamsburg, VA · Accident · No injuries · Limited investigation · Final report · Oct 17, 2011 · N758GY · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA012](https://openairdocs.org/ntsb/WPR12FA012.md): Beech E33 · Daggett, CA · Accident · 3 fatal · Field investigation · Final report · Oct 16, 2011 · N7011N · Substantial damage
  > A loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…
- [NTSB CEN12FA021](https://openairdocs.org/ntsb/CEN12FA021.md): Piper PA-28-140 · Guthrie, OK · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2011 · N6085W · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA047](https://openairdocs.org/ntsb/CEN12LA047.md): Saber Trike unk · Okmulgee, OK · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2011 · UNREG · Substantial damage
  > The in-flight collision with electrical wires for undetermined reasons.
- [NTSB ERA12CA024](https://openairdocs.org/ntsb/ERA12CA024.md): Cessna 182A · Warrenton, VA · Accident · No injuries · Data collection · Final report · Oct 10, 2011 · N6324B · Substantial damage
  > The pilot did not ensure that the forward door latch was secured prior to initiating the descent.
- [NTSB WPR12CA004](https://openairdocs.org/ntsb/WPR12CA004.md): Cessna T310R · Hilo, HI · Accident · No injuries · Data collection · Final report · Oct 8, 2011 · N23BT · Substantial damage
  > A total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.
- [NTSB ERA12FA017](https://openairdocs.org/ntsb/ERA12FA017.md): Luscombe 8A · Dixie, GA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2011 · N41907 · Substantial damage
  > Maintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.
- [NTSB CEN12CA006](https://openairdocs.org/ntsb/CEN12CA006.md): Cessna 210A · Wolfe City, TX · Accident · No injuries · Data collection · Final report · Oct 6, 2011 · N9448X · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.
- [NTSB CEN12LA007](https://openairdocs.org/ntsb/CEN12LA007.md): Piper PA-38-112 · Centerburg, OH · Accident · No injuries · Limited investigation · Final report · Oct 5, 2011 · N6403A · Substantial damage
  > The pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.
- [NTSB ERA12FA012](https://openairdocs.org/ntsb/ERA12FA012.md): Piper PA-32R-300 · Peru, WV · Accident · 3 fatal · Field investigation · Final report · Oct 3, 2011 · N115CL · Substantial damage
  > The non-instrument rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent in-flight collision with mountainous terrain.
- [NTSB ERA12FA002](https://openairdocs.org/ntsb/ERA12FA002.md): Temco GC-1B · Ewell, MD · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2011 · N3825K · Substantial damage
  > The pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.
- [NTSB ERA12WA026](https://openairdocs.org/ntsb/ERA12WA026.md): Beech V35 · Maraba Paulista, Brazil · Accident · 4 fatal · Foreign investigation · Oct 1, 2011 · PT-CTL · Substantial damage
  > On October 1, 2011, about 2345 coordinated universal time (2045 local time), a Beechcraft V35, Brazilian registration PT-CTL, was substantially damaged when it impacted terrain between the cities of Maraba Paulista and Presidente Venceslau, Sao Paulo State,…
- [NTSB CEN12FA001](https://openairdocs.org/ntsb/CEN12FA001.md): Robinson Helicopter R66 · Philip, SD · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2011 · N266CY · Destroyed
  > The in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.
- [NTSB CEN11CA679](https://openairdocs.org/ntsb/CEN11CA679.md): Waltman Theodore J Moose · Hays, KS · Accident · No injuries · Data collection · Final report · Sep 30, 2011 · N384JP · Substantial damage
  > Rudder flutter due to the design changes to the airplane's horizontal stabilizer.
- [NTSB ERA11WA520](https://openairdocs.org/ntsb/ERA11WA520.md): Beech D35 · Avare, Brazil · Accident · 2 fatal · Foreign investigation · Sep 29, 2011 · PT-AVK · Substantial damage
  > On September 29, 2011, about 1824 Universal Coordinated Time (UTC), a Beech D35, Brazilian registration PT-AVK, operated by a private owner, was destroyed following a collision with terrain at Santarém Municipality, State of Pará, Brazil. The local flight…
- [NTSB ERA11CA511](https://openairdocs.org/ntsb/ERA11CA511.md): Boeing 737-823 · Miami, FL · Accident · Serious injuries · Data collection · Final report · Sep 29, 2011 · N804NN · No damage
  > The in-flight encounter with clear air turbulence, which resulted in an injury to a cabin attendant.
- [NTSB DCA11WA108](https://openairdocs.org/ntsb/DCA11WA108.md): Aviocar CASA C212 · Aceh, Indonesia · Accident · 18 fatal · Foreign investigation · Sep 29, 2011 · PK-TLF · Substantial damage
  > The National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an accident involving a Aviocar CASA C212 that occurred on September 29, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation…

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

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

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