# NTSB investigations: Takeoff

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 79 of 281 · 14,038 cases

## Cases, newest first

- [NTSB NYC05CA136](https://openairdocs.org/ntsb/NYC05CA136.md): Hanek Pitts S1S · Mercer, PA · Accident · Minor injuries · Data collection · Final report · Aug 23, 2005 · N184MH · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.
- [NTSB ANC05LA129](https://openairdocs.org/ntsb/ANC05LA129.md): de Havilland Beaver DHC-2 MK.1 · Aleknagik, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 2005 · N5333G · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control during the takeoff roll, and an encounter with high vegetation and a river bank. Factors associated with the accident are high vegetation and a riverbank.
- [NTSB LAX05CA274](https://openairdocs.org/ntsb/LAX05CA274.md): Beech A36 · Healdsburg, CA · Accident · No injuries · Data collection · Final report · Aug 21, 2005 · N7226M · Substantial damage
  > the pilot's failure to maintain lateral aircraft control during takeoff.
- [NTSB CHI05LA237](https://openairdocs.org/ntsb/CHI05LA237.md): Kircher RV-8 · Menomonie, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 21, 2005 · N505DF · Destroyed
  > The pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.
- [NTSB ATL05CA146](https://openairdocs.org/ntsb/ATL05CA146.md): Piper 22 · Archdale, NC · Accident · No injuries · Data collection · Final report · Aug 16, 2005 · N8595C · Substantial damage
  > The pilot's failure to maintain directional control during landing roll, which resulted in a nose over.
- [NTSB DFW05CA216](https://openairdocs.org/ntsb/DFW05CA216.md): Cessna A188B · Winnsboro, LA · Accident · No injuries · Data collection · Final report · Aug 15, 2005 · N4952Q · Substantial damage
  > The pilot's failure to maintain directional control during the take-off roll.
- [NTSB SEA05CA174](https://openairdocs.org/ntsb/SEA05CA174.md): Navion Navion G · Port Orchard, WA · Accident · No injuries · Data collection · Final report · Aug 13, 2005 · N1622T · Substantial damage
  > The pilot's delay in aborting the takeoff which resulted in a runway overrun. A contributing factor was the pilot's failure to raise the flaps prior to takeoff.
- [NTSB CHI05LA233](https://openairdocs.org/ntsb/CHI05LA233.md): North American Navion A (L-17B) · Zeeland, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2005 · N8828H · Substantial damage
  > The loss of engine power after takeoff due to a fuel selector valve leak and low altitude and low airspeed at the time of power loss. A factor was the recommended maintenance service for the fuel selector not performed by the airplane owner/pilot.
- [NTSB CHI05LA226](https://openairdocs.org/ntsb/CHI05LA226.md): Piper PA-28-161 · Culver, IN · Accident · 2 fatal · Limited investigation · Final report · Aug 10, 2005 · N4512Q · Substantial damage
  > The loss of engine power while maneuvering due to partial failure of the left magneto, and the flight instructor's failure to maintain sufficient airspeed to avoid a stall. An additional cause was improper maintenance by company maintenance personnel,…
- [NTSB CHI05LA214](https://openairdocs.org/ntsb/CHI05LA214.md): Grumman G-164 · Marshalltown, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2005 · N636U · Substantial damage
  > The loss of engine power for an undetermined reason. A factor was the corn crop.
- [NTSB CHI05LA213](https://openairdocs.org/ntsb/CHI05LA213.md): Weatherly 620-B · Osage, IA · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2005 · N6305W · Destroyed
  > The partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.
- [NTSB MIA05LA143](https://openairdocs.org/ntsb/MIA05LA143.md): Cirrus Design SR22 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Aug 4, 2005 · N513CD · Substantial damage
  > The manufacturer's defective wheel brake assembly design and a leaking wheel brake, resulting in an overheated brake assembly and a wheel fire during an aborted takeoff.
- [NTSB NYC05IA128](https://openairdocs.org/ntsb/NYC05IA128.md): Beech 1900D · Rockland, ME · Incident · No injuries · Incident investigation · Final report · Aug 2, 2005 · N136MJ · No damage
  > A loose elevator attachment, which resulted in a partial elevator binding during takeoff and uncommanded elevator movement during cruise.
- [NTSB CHI05CA206](https://openairdocs.org/ntsb/CHI05CA206.md): Luscombe 8F · Sturtevant, WI · Accident · No injuries · Data collection · Final report · Jul 31, 2005 · N1841B · Substantial damage
  > The pilot not obtaining/maintaining airplane control during the aborted takeoff. A factor was the berm.
- [NTSB LAX05CA250](https://openairdocs.org/ntsb/LAX05CA250.md): Ayres S2R-134 · Kerman, CA · Accident · No injuries · Data collection · Final report · Jul 30, 2005 · N4003Z · Substantial damage
  > the pilot's failure to obtain an adequate airspeed during an attempted takeoff.
- [NTSB DEN05CA116](https://openairdocs.org/ntsb/DEN05CA116.md): Cessna 210E · Saratoga, WY · Accident · No injuries · Data collection · Final report · Jul 29, 2005 · N2361F · Substantial damage
  > the pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…
- [NTSB SEA05CA152](https://openairdocs.org/ntsb/SEA05CA152.md): Cessna 180 · McCall, ID · Accident · No injuries · Data collection · Final report · Jul 28, 2005 · N90RW · Substantial damage
  > The pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.
- [NTSB ANC05CA108](https://openairdocs.org/ntsb/ANC05CA108.md): Piper PA-18-150 · Aleknagik, AK · Accident · No injuries · Data collection · Final report · Jul 26, 2005 · N6195D · Substantial damage
  > The pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…
- [NTSB DFW05FA188](https://openairdocs.org/ntsb/DFW05FA188.md): Cessna 310Q · Ada, OK · Accident · 3 fatal · Field investigation · Final report · Jul 24, 2005 · N1971W · Destroyed
  > The loss of engine power as a result of a fatigue fracture in one of the crankshaft gear teeth for undetermined reasons. Also causal was the pilot's failure to maintain control of the twin-engine airplane after the power loss, which resulted in an inadvertent…
- [NTSB DFW05LA187](https://openairdocs.org/ntsb/DFW05LA187.md): Yakovlev Yak 52 · Claremore, OK · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 2005 · N2331C · Substantial damage
  > The pilot's failure to obtain adequate airspeed while executing a low altitude aerobatic maneuver, which resulted in an aerodynamic stall while inverted. A factor was the low altitude.
- [NTSB DFW05CA191](https://openairdocs.org/ntsb/DFW05CA191.md): Air Tractor AT-502B · Gassoway, LA · Accident · No injuries · Data collection · Final report · Jul 23, 2005 · N50075 · Substantial damage
  > The pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.
- [NTSB SEA05CA148](https://openairdocs.org/ntsb/SEA05CA148.md): Piper PA-16 · Park City, MT · Accident · No injuries · Data collection · Final report · Jul 20, 2005 · N5942H · Substantial damage
  > The failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.
- [NTSB SEA05LA146](https://openairdocs.org/ntsb/SEA05LA146.md): Grumman G-164A · Jerome, ID · Accident · No injuries · Limited investigation · Final report · Jul 19, 2005 · N6702Q · Substantial damage
  > Failure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.
- [NTSB SEA05LA147](https://openairdocs.org/ntsb/SEA05LA147.md): Piper PA-18-150 · Yellow Pine, ID · Accident · No injuries · Limited investigation · Final report · Jul 17, 2005 · N721JW · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…
- [NTSB CHI05CA195](https://openairdocs.org/ntsb/CHI05CA195.md): Cessna 180 · Bowstring, MN · Accident · No injuries · Data collection · Final report · Jul 17, 2005 · N4652B · Substantial damage
  > The unsuitable water conditions for takeoff selected by the pilot and his inability to maintain aircraft control in the rough water. Contributing factors were the aborted takeoff initiated by the pilot, the rough water conditions and the high, gusty winds.
- [NTSB DEN05LA110](https://openairdocs.org/ntsb/DEN05LA110.md): Cessna TU206F · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2005 · N1059V · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.
- [NTSB CHI05CA184](https://openairdocs.org/ntsb/CHI05CA184.md): Hirsch RV-6A · Oshkosh, WI · Accident · Minor injuries · Data collection · Final report · Jul 14, 2005 · N125WH · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff. Contributing factors were the uneven (rough) runway surface and the fence.
- [NTSB ATL05CA127](https://openairdocs.org/ntsb/ATL05CA127.md): Schweizer 269C-1 · Landrum, SC · Accident · No injuries · Data collection · Final report · Jul 9, 2005 · N301MG · Substantial damage
  > The pilot's improper use of the flight controls (collective pitch and cylic controls) during a take off to a hover resulting in the helicopter encountering dynamic roll over and rolling over on its right side.
- [NTSB CHI05LA176](https://openairdocs.org/ntsb/CHI05LA176.md): Schweizer G-164B · Buxton, ND · Accident · No injuries · Limited investigation · Final report · Jul 7, 2005 · N6631Q · Substantial damage
  > A loss of engine power on takeoff due to undetermined reasons. A factor was the ditch that the airplane contacted during the forced landing.
- [NTSB NYC05CA115](https://openairdocs.org/ntsb/NYC05CA115.md): Wagner Kitfox II · Albion, NY · Accident · Minor injuries · Data collection · Final report · Jul 6, 2005 · N16AF · Substantial damage
  > The pilot's loss of airplane control after inadvertently taking off while conducting high-speed taxi runs. A factor related to the accident was the pilot's lack of experience in the airplane.
- [NTSB DFW05CA157](https://openairdocs.org/ntsb/DFW05CA157.md): Grumman AA1B · Llano, TX · Accident · Serious injuries · Data collection · Final report · Jul 5, 2005 · N1466R · Substantial damage
  > The partial loss of engine power for undetermined reasons during takeoff resulting in an overrun. A factor was the high density altitude.
- [NTSB CHI05FA162](https://openairdocs.org/ntsb/CHI05FA162.md): Piper PA-46-310P · Grand Rapids, MN · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2005 · N4386G · Destroyed
  > An observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…
- [NTSB IAD05LA091](https://openairdocs.org/ntsb/IAD05LA091.md): Cessna 152 · Concord, NH · Accident · No injuries · Limited investigation · Final report · Jul 3, 2005 · N48017 · Substantial damage
  > The student pilot's failure to maintain airspeed, and the flight instructor's inadequate remedial action, which resulted in an inadvertant stall and uncontrolled descent into terrain.
- [NTSB ATL05CA120](https://openairdocs.org/ntsb/ATL05CA120.md): Grumman American AA-1B · Durham, NC · Accident · No injuries · Data collection · Final report · Jul 3, 2005 · N100XX · Destroyed
  > The pilot's failure to maintain directional control. Factors were soft and wet terrain.
- [NTSB MIA05LA127](https://openairdocs.org/ntsb/MIA05LA127.md): Air Tractor AT-502 · Fort Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 2005 · N4515V · Substantial damage
  > The failure of the pilot to abort the takeoff after a reported loss of engine power during the takeoff roll, resulting in the in-flight collision with a fence and trees. A factor in the accident was the failure of the pilot to lower the flaps to 10 degrees as…
- [NTSB CHI05CA161](https://openairdocs.org/ntsb/CHI05CA161.md): Mueller Stewart Headwind B · Cloverdale, IN · Accident · Minor injuries · Data collection · Final report · Jul 1, 2005 · N64MF · Substantial damage
  > The fuel starvation leading to the loss of engine power during takeoff. Factors were the pilot's insufficient information on the fuel system and the sign that had to be circumnavigated during the forced landing.
- [NTSB CHI05LA160](https://openairdocs.org/ntsb/CHI05LA160.md): Piper PA-32RT-300 · Kansas City, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2005 · N21835 · Destroyed
  > The pilot not maintaining climb airspeed leading to the airplane's impact with the fence and terrain during takeoff. Factors in the accident were the pilot's inaccurate preflight planning calculations, the fence, and the levee.
- [NTSB ATL05LA118](https://openairdocs.org/ntsb/ATL05LA118.md): Piper PA-31P · Fort Payne, AL · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2005 · N4200N · Substantial damage
  > The loss of engine power due to the failure of the aft clamp connecting the turbocharger compressor outlet to the intercooler ducting which resulted in reduced aircraft performance during takeoff.
- [NTSB SEA05CA131](https://openairdocs.org/ntsb/SEA05CA131.md): Maule M-7-235B · Hermiston, OR · Accident · No injuries · Data collection · Final report · Jun 24, 2005 · N333DD · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff ground roll which resulted in overload damage to the main landing gear. During the landing roll, it was not possible to maintain aircraft control due to the previously damaged gear.…
- [NTSB SEA05CA119](https://openairdocs.org/ntsb/SEA05CA119.md): Adkins Ridge Runner II · Pocatello, ID · Accident · No injuries · Data collection · Final report · Jun 19, 2005 · N825PB · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.
- [NTSB LAX05CA212](https://openairdocs.org/ntsb/LAX05CA212.md): Piper PA-18-135 · Pine Valley, CA · Accident · No injuries · Data collection · Final report · Jun 19, 2005 · N2663A · Substantial damage
  > The pilot's delay in aborting the takeoff and excessive brake application. A contributing factor was the downsloping terrain used for the landing and takeoff.
- [NTSB CHI05LA154](https://openairdocs.org/ntsb/CHI05LA154.md): Cessna A188B · Washburn, ND · Accident · No injuries · Limited investigation · Final report · Jun 19, 2005 · N774T · Substantial damage
  > The separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.
- [NTSB DFW05CA161](https://openairdocs.org/ntsb/DFW05CA161.md): Cessna A188B · Osceola, AR · Accident · No injuries · Data collection · Final report · Jun 15, 2005 · N4894R · Substantial damage
  > The pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.
- [NTSB CHI05CA141](https://openairdocs.org/ntsb/CHI05CA141.md): Quicksilver Sport 2S · Maize, KS · Accident · No injuries · Data collection · Final report · Jun 15, 2005 · N44242 · Substantial damage
  > The pilot's inadequate preflight planning that failed to ensure adequate takeoff performance, and his delay in aborting the takeoff.
- [NTSB NYC05FA099](https://openairdocs.org/ntsb/NYC05FA099.md): Bell 206L · New York, NY · Accident · Serious injuries · Field investigation · Final report · Jun 14, 2005 · N78TD · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.
- [NTSB CHI05CA146](https://openairdocs.org/ntsb/CHI05CA146.md): Cessna 172N · Madison, WI · Accident · No injuries · Data collection · Final report · Jun 13, 2005 · N6454J · Substantial damage
  > The pilot's improper pre-flight which resulted in the control lock not being removed and his subsequent inability to control the airplane. The unmarked control lock and the FBO's failure to replace the unmarked control lock were factors in the accident.
- [NTSB DFW05CA154](https://openairdocs.org/ntsb/DFW05CA154.md): Cessna 152 · Marietta, OK · Accident · No injuries · Data collection · Final report · Jun 11, 2005 · N47962 · Substantial damage
  > The pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.
- [NTSB DEN05LA088](https://openairdocs.org/ntsb/DEN05LA088.md): Beech S35 · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Jun 11, 2005 · N2FY · Substantial damage
  > the flight instructor and pilot's improper decision to continue the attempted high altitude takeoff when Vy airspeed was not obtained, and failure to abort the takeoff which resulted in an off-field landing and subsequent impact with terrain. A contributing…
- [NTSB ANC05LA082](https://openairdocs.org/ntsb/ANC05LA082.md): deHavilland DHC-2 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Jun 10, 2005 · N43446 · Substantial damage
  > The pilot's failure to correct for torque/P-Factor during the takeoff run, and his delay in aborting the takeoff, which resulted in a loss of directional control and subsequent wing collision with the surface of the water. A factor contributing to the…
- [NTSB NYC05IA095](https://openairdocs.org/ntsb/NYC05IA095.md): Airbus Industrie A330-301 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Jun 9, 2005 · EI-ORD · 2 aircraft · No damage
  > The local east controller's failure to follow FAA Order 7110.65, para 3-9-8 and Boston Tower Order 7110.11, Standard Operating Procedures, which resulted in a runway incursion during takeoff involving two transport category airplanes.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=80

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

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

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