# NTSB investigations, 2007: Unknown

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 DFW08LA134](https://openairdocs.org/ntsb/DFW08LA134.md): Cessna 310 · Glenwood, NM · Accident · 2 fatal · Limited investigation · Final report · Dec 21, 2007 · N28836 · Destroyed
  > A loss of control for undetermined reasons. Contributing to the accident was the marginal weather conditions in the area at the time of the accident.
- [NTSB MIA08FA026](https://openairdocs.org/ntsb/MIA08FA026.md): Cessna R182 · Woodland, AL · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2007 · N2643C · Destroyed
  > The flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…
- [NTSB CHI08LA041](https://openairdocs.org/ntsb/CHI08LA041.md): Herink H R/Herink R W Challenger · Apple River, IL · Accident · 1 fatal · Limited investigation · Final report · Nov 27, 2007 · N2159M · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the low altitude and the gusty wind conditions.
- [NTSB LAX08LA024](https://openairdocs.org/ntsb/LAX08LA024.md): North Wing Mustang II 17.5 · Tracy, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 2007 · UNREG · Substantial damage
  > Failure or disconnection of a wing support/brace assembly for undetermined reasons during an undetermined phase of flight.
- [NTSB CHI08CA011](https://openairdocs.org/ntsb/CHI08CA011.md): Cessna 172P · Belleville, IL · Accident · No injuries · Data collection · Final report · Sep 29, 2007 · N65998 · Substantial damage
  > the design limits of the aircraft being exceeded by a previous pilot during an unknown phase of flight.
- [NTSB NYC07FAMS1](https://openairdocs.org/ntsb/NYC07FAMS1.md): Piper PA-32-260 · Westhampton, NY · Accident · 1 fatal · Missing aircraft · Final report · Aug 25, 2007 · N5067T · Destroyed
  > Undetermined. The airplane remains missing.
- [NTSB CHI07FA279](https://openairdocs.org/ntsb/CHI07FA279.md): Socata TB-20 Trinidad · Pointe Aux Pins, MI · Accident · 2 fatal · Field investigation · Final report · Aug 24, 2007 · N96DF · Substantial damage
  > Undetermined.
- [NTSB DFW07LA170](https://openairdocs.org/ntsb/DFW07LA170.md): Hazen Fly Baby · Page, OK · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2007 · N6156Y · Substantial damage
  > The airplane's collision with wooded and mountainous terrain for undetermined reasons.
- [NTSB LAX07FAMS1](https://openairdocs.org/ntsb/LAX07FAMS1.md): Cub Crafters CC11-100 · Aurora, OR · Accident · 1 fatal · Missing aircraft · Final report · Jul 7, 2007 · N222TB · Destroyed
  > The airplane is missing.
- [NTSB DFW07LA160](https://openairdocs.org/ntsb/DFW07LA160.md): Ingraham RV-6 · Carlsbad, NM · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 2007 · N320TX · Destroyed
  > The pilot's loss of control for undetermined reasons.

## 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 year(c."eventDate") = 2007
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?year=2007

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