# NTSB investigations, CA: 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 1 of 23 · 1,146 cases

## Latest cases

- [NTSB WPR26LA337](https://openairdocs.org/ntsb/WPR26LA337.md): Wawrzynski Vincent P RV-7 · Columbia, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 9, 2026 · N1003 · Substantial damage
- [NTSB WPR26LA367](https://openairdocs.org/ntsb/WPR26LA367.md): Hawker Beechcraft G36 · Murrieta, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 30, 2026 · N646MM · Substantial damage
  > On August 30, 2026, at 1040 Pacific daylight time, a Hawker Beechcraft G36, N646MM, was substantially damaged when it was involved in an accident near Murrieta, California. The student pilot, flight instructor, and 4 passengers were not injured. The airplane…
- [NTSB WPR26LA282](https://openairdocs.org/ntsb/WPR26LA282.md): Mark Lee Schillinger GT-VX2 · Petaluma, CA · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jul 30, 2026 · N556GT · Substantial damage
- [NTSB WPR26LA237](https://openairdocs.org/ntsb/WPR26LA237.md): Autogyro MT03 · San Jose, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 29, 2026 · N423AG · Substantial damage
  > On June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received…
- [NTSB WPR26LA207](https://openairdocs.org/ntsb/WPR26LA207.md): Bell 47G-2 · Mettler, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 1, 2026 · N88755 · Substantial damage
  > The pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…
- [NTSB WPR26LA213](https://openairdocs.org/ntsb/WPR26LA213.md): Moose SR 2500 · Sonoma, CA · Accident · Serious injuries · Class 4 · Limited · Final report · May 27, 2026 · N135DS · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB WPR26LA159](https://openairdocs.org/ntsb/WPR26LA159.md): Cirrus Design SR22T · Fullerton, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 13, 2026 · N285AH · Substantial damage
  > The pilot’s loss of control during takeoff, due to the seat sliding aft.
- [NTSB WPR26LA115](https://openairdocs.org/ntsb/WPR26LA115.md): Mightyfly MF-100 · Atwater, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 2, 2026 · N258MF · Destroyed
  > A control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.
- [NTSB WPR26FA069](https://openairdocs.org/ntsb/WPR26FA069.md): Piper PA-32-260 · Rio Linda, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 24, 2025 · N2785Q · Substantial damage
  > On December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was…
- [NTSB WPR26LA038](https://openairdocs.org/ntsb/WPR26LA038.md): Cessna 182P · San Andreas, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 3, 2025 · N1303S · Substantial damage
  > The pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.
- [NTSB WPR25LA288](https://openairdocs.org/ntsb/WPR25LA288.md): Cessna 750 · San Diego, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 18, 2025 · N769XJ · Substantial damage
  > On September 17, 2025, about 1742 Pacific daylight time, a Cessna 750, N769XJ, was substantially damaged when it was involved in an accident at San Diego International Airport (SAN), San Diego, California. The two pilots and four passengers sustained no…
- [NTSB WPR25LA195](https://openairdocs.org/ntsb/WPR25LA195.md): Cessna 150F · Tracy, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 28, 2025 · N6744F · Substantial damage
  > On June 28, 2025, about 1420 Pacific daylight time, a Cessna 150F, N6744F, was substantially damaged when it was involved in an accident at Tracy Municipal Airport (TCY), Tracy, California. The pilot was not injured. The airplane was operated as a Title 14…
- [NTSB ANC25LA040](https://openairdocs.org/ntsb/ANC25LA040.md): Cirrus Design SR22T · San Luis Obispo, CA · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2025 · N797CK · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB WPR25FA145](https://openairdocs.org/ntsb/WPR25FA145.md): Champion 7ECA · Cottonwood, CA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2025 · N6310N · Destroyed
  > The flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.
- [NTSB WPR25LA139](https://openairdocs.org/ntsb/WPR25LA139.md): Diamond Aircraft Ind DA 40 · Oakland, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 20, 2025 · N22QT · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff with a left quartering crosswind.
- [NTSB WPR25LA132](https://openairdocs.org/ntsb/WPR25LA132.md): Cessna 180J · Oakland, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 10, 2025 · N7779K · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff roll with a left crosswind.
- [NTSB WPR24FA295](https://openairdocs.org/ntsb/WPR24FA295.md): Piper PA-24-250 · Hawthorne, CA · Accident · Serious injuries · Class 3 · Field · Preliminary report · Sep 6, 2024 · N588CP · Destroyed
  > On September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…
- [NTSB WPR24LA293](https://openairdocs.org/ntsb/WPR24LA293.md): Cessna 152 · Amboy, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 2, 2024 · N66948 · Substantial damage
  > The pilot's failure to maintain clearance from a street sign during takeoff from a road.
- [NTSB WPR24FA290](https://openairdocs.org/ntsb/WPR24FA290.md): Aero Commander 200D · Novato, CA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 31, 2024 · N2912T · Substantial damage
  > The pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.
- [NTSB WPR24LA251](https://openairdocs.org/ntsb/WPR24LA251.md): Robinson Helicopter R44 · Carlsbad, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 18, 2024 · N886JB · Substantial damage
  > The pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.
- [NTSB WPR24LA244](https://openairdocs.org/ntsb/WPR24LA244.md): Piper PA-28R-200 · Lakeport, CA · Accident · No injuries · Class 4 · Limited · Final report · Jul 12, 2024 · N4443X · Substantial damage
  > A collision with a deer during takeoff.
- [NTSB WPR24LA219](https://openairdocs.org/ntsb/WPR24LA219.md): Cessna 172L · Oxnard, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 29, 2024 · N2835Q · Substantial damage
  > The student pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB WPR24LA214](https://openairdocs.org/ntsb/WPR24LA214.md): Grumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 25, 2024 · N6793K · Substantial damage
  > The pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.
- [NTSB WPR24LA186](https://openairdocs.org/ntsb/WPR24LA186.md): Grumman/Schweizer G-164D · Richvale, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 8, 2024 · N6736K · Substantial damage
  > The pilot’s decision to take off with a tailwind and their failure to maintain clearance from terrain.
- [NTSB ANC24FA038](https://openairdocs.org/ntsb/ANC24FA038.md): Schweizer G-164B · Richvale, CA · Accident · 1 fatal · Class 3 · Field · Final report · May 28, 2024 · N3629Y · Substantial damage
  > The pilot’s failure to maintain clearance from a trailer located on the edge of the runway during takeoff. Contributing to the accident was the location of the trailer on the side of the runway.
- [NTSB WPR24LA145](https://openairdocs.org/ntsb/WPR24LA145.md): Cessna 195 · Big Bear, CA · Accident · No injuries · Class 4 · Limited · Final report · May 9, 2024 · N2193C · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff with a gusty crosswind.
- [NTSB DCA24LA110](https://openairdocs.org/ntsb/DCA24LA110.md): Boeing 757-224 · San Francisco, CA · Accident · No injuries · Class 4 · Limited · Final report · Feb 26, 2024 · N13138 · Substantial damage
  > The crew’s over-rotation of the aircraft pitch during takeoff which resulted in a tailstrike.
- [NTSB WPR24FA080](https://openairdocs.org/ntsb/WPR24FA080.md): Swanson R/Swanson S RV-6 · Concord, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 30, 2024 · N30AK · Substantial damage
  > A total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.
- [NTSB WPR24FA056](https://openairdocs.org/ntsb/WPR24FA056.md): Vans RV8 · Corona, CA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 16, 2023 · N6948L · Substantial damage
  > Fuel contamination from the pilot’s improper application of a sealant to the fuel tank, which resulted in a partial loss of engine power on takeoff.
- [NTSB WPR23LA357](https://openairdocs.org/ntsb/WPR23LA357.md): Cessna 172R · Redding, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2023 · N17274 · Substantial damage
  > The student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.
- [NTSB WPR23LA349](https://openairdocs.org/ntsb/WPR23LA349.md): Cessna 172N · Compton, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 20, 2023 · N733ZN · Substantial damage
  > The total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.
- [NTSB WPR23LA333](https://openairdocs.org/ntsb/WPR23LA333.md): Ayres S2R-T34 · Three Rocks, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 1, 2023 · N61373 · Substantial damage
  > The airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.
- [NTSB WPR23LA363](https://openairdocs.org/ntsb/WPR23LA363.md): Piper PA-32-300 · Needles, CA · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2023 · N2957N · Substantial damage
  > An encounter with windshear during the initial climb after takeoff, resulting in a loss of control and a subsequent hard landing.
- [NTSB WPR23LA315](https://openairdocs.org/ntsb/WPR23LA315.md): Cessna 172M · Marysville, CA · Accident · No injuries · Class 4 · Limited · Final report · Aug 10, 2023 · N20268 · Substantial damage
  > The flight instructor’s failure to monitor the airplane’s speed during a high-speed taxi, resulting in a runway excursion.
- [NTSB WPR23LA270](https://openairdocs.org/ntsb/WPR23LA270.md): Sling Sling LSA · Palm Springs, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2023 · N294JY · Substantial damage
  > Failure of the landing gear strut during takeoff due to a preexisting cracks that were caused by a manufacturing anomaly during the composite fiber layup process.
- [NTSB WPR23FA247](https://openairdocs.org/ntsb/WPR23FA247.md): Cessna 172N · Murrieta, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 4, 2023 · N5243E · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the loss of control was the pilot’s sudden retraction of the flaps.
- [NTSB WPR23LA229](https://openairdocs.org/ntsb/WPR23LA229.md): Cessna 305C (0-1E) · Big Bear City, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 17, 2023 · N62TX · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during takeoff.
- [NTSB WPR23LA217](https://openairdocs.org/ntsb/WPR23LA217.md): Air Tractor AT-502B · Bakersfield, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 5, 2023 · N6174W · Substantial damage
  > The pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.
- [NTSB WPR23LA212](https://openairdocs.org/ntsb/WPR23LA212.md): Grumman Acft ENG Cor-Schweizer G-164B · Colusa, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 4, 2023 · N6750K · Substantial damage
  > The pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. Contributing to the accident was the pilot’s fatigue.
- [NTSB WPR23LA165](https://openairdocs.org/ntsb/WPR23LA165.md): Oneal J R/Oneal R C EDI Express · Tracy, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 24, 2023 · N92734 · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB WPR23LA124](https://openairdocs.org/ntsb/WPR23LA124.md): Cessna 172N · Van Nuys, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 10, 2023 · N73726 · Substantial damage
  > The pilots failure to maintain directional control during takeoff.
- [NTSB DCA23LA185](https://openairdocs.org/ntsb/DCA23LA185.md): Bombardier CL-600-2D24 · Burbank, CA · Incident · No injuries · Class 3 · Limited · Final report · Feb 23, 2023 · N954LR · 2 aircraft · No damage
  > The interruption of the local controller’s workflow due to the necessitated management of a go-around of a third airplane that was approaching a different runway. Contributing to the incident was: 1) the controller’s decision to continue the landing of…
- [NTSB WPR23LA091](https://openairdocs.org/ntsb/WPR23LA091.md): Piper PA-28-180 · San Diego, CA · Accident · No injuries · Class 4 · Limited · Final report · Jan 15, 2023 · N9687J · Substantial damage
  > The flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…
- [NTSB WPR23LA074](https://openairdocs.org/ntsb/WPR23LA074.md): Royse Ralph L Glasair · Cottonwood, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 17, 2022 · N9YA · Substantial damage
  > The pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.
- [NTSB WPR23LA045](https://openairdocs.org/ntsb/WPR23LA045.md): Sikorsky UH-60A · San Diego, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 23, 2022 · N160AQ · 2 aircraft · Substantial damage
  > The failure of the crewmembers of the second helicopter to maintain visual separation with the first helicopter while complying with the LC controller’s instruction to go around. Contributing to the accident were the nighttime conditions and the lack of a…
- [NTSB WPR23LA021](https://openairdocs.org/ntsb/WPR23LA021.md): Cessna 140 · Georgetown, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 20, 2022 · N55DC · Substantial damage
  > The pilot’s failure to maintain control during an attempted go-around, which resulted in a runway excursion and a separation of the right main landing gear.
- [NTSB WPR22LA320](https://openairdocs.org/ntsb/WPR22LA320.md): Cessna 152 · Ione, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 26, 2022 · N49430 · Substantial damage
  > The flight instructor’s delayed decision to abort the takeoff, which resulted in impact with a fence and a tree. Contributing to the accident was the instructor’s decision to land at the unfamiliar airstrip without determining whether it was within the…
- [NTSB WPR22FA265](https://openairdocs.org/ntsb/WPR22FA265.md): North American T-28B · Fallbrook, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 23, 2022 · N787AS · Substantial damage
  > A loss of power due to an unmaintained carburetor diaphragm and inoperative electric fuel pump that resulted in fuel starvation to the engine.
- [NTSB WPR22LA232](https://openairdocs.org/ntsb/WPR22LA232.md): Maule MX-7-235 · Copperopolis, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2022 · N13ZF · Substantial damage
  > The pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.
- [NTSB WPR22FA210](https://openairdocs.org/ntsb/WPR22FA210.md): Mooney M20K · Camarillo, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 10, 2022 · N305L · Destroyed
  > The pilot’s spatial disorientation and loss of airplane control after entering instrument meteorological conditions shortly after takeoff.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?state=CA&page=2

## 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND 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?state=CA

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