# NTSB investigations, CA: Prior to flight

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.

## Latest cases

- [NTSB WPR24LA030](https://openairdocs.org/ntsb/WPR24LA030.md): Arrow Falcon Exporters UH-1H · Firebaugh, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 4, 2023 · N3053Q · Substantial damage
  > An on-ground fuel fire for reasons that could not be determined due to extensive thermal damage.
- [NTSB WPR21LA342](https://openairdocs.org/ntsb/WPR21LA342.md): Beech 58 · Palo Alto, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 13, 2021 · N162DF · Substantial damage
  > The fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.
- [NTSB DCA19CA186](https://openairdocs.org/ntsb/DCA19CA186.md): Boeing 757 · San Francisco, CA · Accident · No injuries · Class 4 · Data collection · Final report · Jul 23, 2019 · N57852 · Substantial damage
  > failure of the ground crew to maintain clearance from the parked airplane during pushback.
- [NTSB WPR18LA058](https://openairdocs.org/ntsb/WPR18LA058.md): Cessna 210 · San Bernardino, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2017 · N222AT · Substantial damage
  > The fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…
- [NTSB DCA18CA074](https://openairdocs.org/ntsb/DCA18CA074.md): Boeing 737 7H4 · Los Angeles, CA · Accident · Serious injuries · Data collection · Final report · Nov 19, 2017 · N740SW · No damage
  > The provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.
- [NTSB GAA17CA119](https://openairdocs.org/ntsb/GAA17CA119.md): Cessna 175 · Lakeport, CA · Accident · No injuries · Data collection · Final report · Jan 6, 2017 · N8148T · Substantial damage
  > The pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.
- [NTSB DCA14CA090](https://openairdocs.org/ntsb/DCA14CA090.md): Boeing 737 - 932ER · San Diego, CA · Accident · Serious injuries · Data collection · Final report · Mar 5, 2014 · N809DN · No damage
  > the flight attendant's inadvertent trip and fall over a passenger bag that was in the aisle.
- [NTSB WPR13LA385](https://openairdocs.org/ntsb/WPR13LA385.md): Robert Golding Tbirdii · Bakersfield, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2013 · N31683 · Substantial damage
  > The failure of the two pilots to adequately planflight, particularly regarding their roles and responsibilities, which resulted in their failure to maintain sufficient altitude to clear power lines during a low pass.
- [NTSB WPR11LA150](https://openairdocs.org/ntsb/WPR11LA150.md): Cessna 140A · Newark, CA · Accident · No injuries · Limited investigation · Final report · Feb 26, 2011 · N5351C · Substantial damage
  > A loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.

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

This list as a web page: https://openairdocs.org/ntsb-phases/100/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.