OpenAirDocs.org

NTSB investigations, IN

19 cases where the phase of flight was Unknown.

Cases per year

19672026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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\" = 'IN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…Nov 4, 2025 · N24157 · Substantial damageNTSB CEN23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · Evansville, INThe total loss of engine power for reasons that could not be determined based on the available evidence.Oct 30, 2022 · N349SB · Substantial damageNTSB CEN20FA098Accident · 1 fatalClass 3 · FieldFinal reportInnovator Mosquitto · North Manchester, INThe pilot’s loss of control for reasons that could not be determined based on the available information.Feb 23, 2020 · N840GS · Substantial damageNTSB CEN14CA155Accident · No injuriesData collectionFinal reportCessna 172M · South Bend, INThe pilot involved and the phase of flight when the damage was incurred were not determined.Feb 26, 2014 · N9801V · Substantial damageNTSB CHI02FA140Accident · 1 fatalField investigationFinal reportSchutte Ms. Ryan Special · Anderson, INThe pilot's failure to properly install the canard attach bolts prior to the flight and the resulting inflight separation of the canard.May 23, 2002 · N827CM · DestroyedNTSB CHI01FA257Accident · 2 fatalField investigationFinal reportSchweizer 269C · Waterloo, INAircraft control not maintained for undetermined reasons.Aug 5, 2001 · N6129M · Substantial damageNTSB CHI98FA099Accident · 1 fatalField investigationFinal reportCessna T210L · Orleans, INThe pilot's attempted VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance with trees. Contributing factors were the pilot's impairment from prescription drugs, low ceilings, fog, trees, and hilly terrain.Mar 5, 1998 · N2546S · DestroyedNTSB CHI97LA163Accident · 1 fatalLimited investigationFinal reportSiefert 5151RG · Shelbyville, INthe cause of the accident is undetermined.Jun 10, 1997 · N81728 · DestroyedNTSB CHI96FA334Accident · 2 fatalField investigationFinal reportThocker RV-4 · Muncie, INwas the in-flight disconnection of the horizontal and vertical stabilizer forward attachments.Sep 17, 1996 · N952JT · DestroyedNTSB CHI93FAMS4Accident · 1 fatalMissing aircraftFinal reportMooney M20K · Hobart, INundetermined.Jun 25, 1993 · N5655M · DestroyedNTSB CHI93FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 182P · Portage, INUndetermined.Feb 6, 1993 · N7227N · DestroyedNTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.Jun 21, 1989 · N30BS · DestroyedNTSB CHI88FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Middletown, INAttempted operation of the accident airplane by the PIC when he was under the influence of alcohol.Jul 7, 1988 · N6187D · DestroyedNTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.Mar 24, 1988 · N7797Q · DestroyedNTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…Jan 8, 1988 · N4878G · DestroyedNTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.Jan 5, 1988 · N6487P · DestroyedNTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNov 19, 1977 · N3095R · DestroyedNTSB CHI70AC079Accident · 2 fatalClosedCessna 150H · Greenwood, INMay 12, 1970 · N7208S · DestroyedNTSB CHI68A0042Accident · 3 fatalClosedBrantly 305 · Taswell, INNov 3, 1967 · N2208U · Destroyed