# NTSB investigations, IA: Approach

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 5 · 233 cases

## Latest cases

- [NTSB CEN26LA271](https://openairdocs.org/ntsb/CEN26LA271.md): Beech V35 · Carroll, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2026 · N3707Q · Substantial damage
  > On July 24, 2026, about 1550 central daylight time, a Beech V35 airplane, N3707Q, was substantially damaged when it was involved in an accident near Carroll, Iowa. The pilot was not injured. The flight was operated under the provisions of Title 14 Code of…
- [NTSB CEN25LA172](https://openairdocs.org/ntsb/CEN25LA172.md): Golden Circle Air T-Bird · Dallas Center, IA · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2025 · N7192M · Substantial damage
  > The pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.
- [NTSB CEN24LA355](https://openairdocs.org/ntsb/CEN24LA355.md): Just SuperStol · Mount Vernon, IA · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 12, 2024 · N874FT · Substantial damage
  > The pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.
- [NTSB CEN24LA079](https://openairdocs.org/ntsb/CEN24LA079.md): Cirrus Design SR22T · Davenport, IA · Accident · No injuries · Class 3 · Limited · Final report · Dec 31, 2023 · N773GB · Substantial damage
  > The fatigue failure of the No. 5 cylinder head, which resulted in a total loss of engine power. Contributing to the accident was the maintenance which did not fully blend to the depth necessary to preclude the failure.
- [NTSB CEN23LA240](https://openairdocs.org/ntsb/CEN23LA240.md): Taylorcraft BC-65 · Sibley, IA · Accident · No injuries · Class 4 · Limited · Final report · Jun 15, 2023 · N23679 · Substantial damage
  > The pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.
- [NTSB CEN23LA076](https://openairdocs.org/ntsb/CEN23LA076.md): Cessna 182M · Council Bluffs, IA · Accident · No injuries · Class 3 · Limited · Final report · Jan 5, 2023 · N71494 · Substantial damage
  > The partial loss of engine power for reasons that could not be determined.
- [NTSB CEN23FA059](https://openairdocs.org/ntsb/CEN23FA059.md): Engineering & Research Ercoupe 415-C · Corning, IA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 5, 2022 · N99345 · Destroyed
  > The pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.
- [NTSB CEN22LA084](https://openairdocs.org/ntsb/CEN22LA084.md): Textron 525 · Dubuque, IA · Accident · No injuries · Class 4 · Limited · Final report · Dec 21, 2021 · N287CB · Substantial damage
  > An inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.
- [NTSB CEN21LA419](https://openairdocs.org/ntsb/CEN21LA419.md): Thatcher CX4 · Marshalltown, IA · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 9, 2021 · N306TA · Substantial damage
  > The pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.
- [NTSB CEN21FA299](https://openairdocs.org/ntsb/CEN21FA299.md): Cirrus Design SR22 · Lamoni, IA · Accident · 2 fatal · Class 3 · Field · Final report · Jul 1, 2021 · N123RE · Destroyed
  > The pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.
- [NTSB CEN20LA276](https://openairdocs.org/ntsb/CEN20LA276.md): Rockwell S2R R1340 · Keokuk, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 12, 2020 · N3104S · Substantial damage
  > The improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.
- [NTSB CEN20LA261](https://openairdocs.org/ntsb/CEN20LA261.md): Enstrom 280 · Des Moines, IA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 4, 2020 · N282SH · Destroyed
  > The partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…
- [NTSB GAA19CA363](https://openairdocs.org/ntsb/GAA19CA363.md): Cessna 150 · Elkader, IA · Accident · No injuries · Data collection · Final report · Jun 20, 2019 · N6471F · Substantial damage
  > The pilot's delayed decision to go around, which resulted in a collision with trees and terrain.
- [NTSB CEN18LA278](https://openairdocs.org/ntsb/CEN18LA278.md): Aero Commander S2R · Vinton, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 17, 2018 · N5553X · Substantial damage
  > Loss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.
- [NTSB GAA17CA317](https://openairdocs.org/ntsb/GAA17CA317.md): Cessna 177 · Guttenberg, IA · Accident · No injuries · Data collection · Final report · Jun 3, 2017 · N34462 · Substantial damage
  > The pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.
- [NTSB GAA16CA501](https://openairdocs.org/ntsb/GAA16CA501.md): Piper PA28R · Ottumwa, IA · Accident · No injuries · Data collection · Final report · Sep 21, 2016 · N3803T · Substantial damage
  > The pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the…
- [NTSB CEN16FA062](https://openairdocs.org/ntsb/CEN16FA062.md): Piper PA46 500TP · Council Bluffs, IA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2015 · N145JR · Substantial damage
  > The pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.
- [NTSB GAA15CA138](https://openairdocs.org/ntsb/GAA15CA138.md): Quicksilver MXL II Sport · Ute, IA · Accident · Serious injuries · Data collection · Final report · Jun 25, 2015 · UNREG · Substantial damage
  > The pilot's failure to maintain sufficient airspeed to prevent an inadvertent aerodynamic stall, and impact with terrain.
- [NTSB CEN15FA008](https://openairdocs.org/ntsb/CEN15FA008.md): Piper PA46 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2014 · N9126V · Destroyed
  > The pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.
- [NTSB CEN13LA570](https://openairdocs.org/ntsb/CEN13LA570.md): Piper PA 28-181 · Algona, IA · Accident · No injuries · Limited investigation · Final report · Sep 30, 2013 · N31688 · Substantial damage
  > Fuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.
- [NTSB CEN13CA133](https://openairdocs.org/ntsb/CEN13CA133.md): American General Acft AG5B · Ankeny, IA · Accident · No injuries · Data collection · Final report · Jan 12, 2013 · N897GA · Substantial damage
  > The pilot’s failure to maintain a proper glide path to the runway in gusty wind conditions and his failure to maintain clearance from obstructions during the subsequent go-around. Contributing to the accident was the pilot's improper interior lighting…
- [NTSB CEN13FA078](https://openairdocs.org/ntsb/CEN13FA078.md): Taylorcraft BC12-D · Clutier, IA · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2012 · N94973 · Substantial damage
  > The pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…
- [NTSB CEN11LA148](https://openairdocs.org/ntsb/CEN11LA148.md): Beech H35 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Dec 18, 2010 · N5537D · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.
- [NTSB CEN10LA401](https://openairdocs.org/ntsb/CEN10LA401.md): Klemme William H Zenith CH 701 · Iowa Falls, IA · Accident · 1 fatal · Limited investigation · Final report · Jul 15, 2010 · N701KC · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while on final approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the model of airplane.
- [NTSB CEN10CA349](https://openairdocs.org/ntsb/CEN10CA349.md): Piper PA-28-151 · Webster, IA · Accident · No injuries · Data collection · Final report · May 9, 2010 · N8083C · Substantial damage
  > The pilot misjudged his speed and distance during landing, which resulted in an overrun.
- [NTSB CEN10FA119](https://openairdocs.org/ntsb/CEN10FA119.md): Piper PA-31T · Forest City, IA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 2010 · N250TT · Substantial damage
  > The pilot's failure to maintain airplane control during final approach.
- [NTSB CEN10CA100](https://openairdocs.org/ntsb/CEN10CA100.md): Cessna P172D · Cedar Rapids, IA · Accident · Minor injuries · Data collection · Final report · Jan 18, 2010 · N8584X · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.
- [NTSB CEN10LA103](https://openairdocs.org/ntsb/CEN10LA103.md): Cessna 177RG · Cedar Rapids, IA · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2010 · N53120 · Substantial damage
  > The pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.
- [NTSB CEN09CA532](https://openairdocs.org/ntsb/CEN09CA532.md): Piper PA-28-161 · Washington, IA · Accident · Serious injuries · Data collection · Final report · Aug 16, 2009 · N47539 · Substantial damage
  > A loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.
- [NTSB CEN09LA491](https://openairdocs.org/ntsb/CEN09LA491.md): Cessna 182J · Iowa Falls, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2009 · N989TP · 2 aircraft · Substantial damage
  > Both pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.
- [NTSB CEN09CA021](https://openairdocs.org/ntsb/CEN09CA021.md): Cessna 150M · Iowa City, IA · Accident · Serious injuries · Data collection · Final report · Oct 7, 2008 · N533JR · Substantial damage
  > Fuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.
- [NTSB CHI08CA261](https://openairdocs.org/ntsb/CHI08CA261.md): Ntbk Wag Aero Sport · Oxford, IA · Accident · Minor injuries · Data collection · Final report · Aug 21, 2008 · N141ST · Substantial damage
  > The pilot misjudged his approach path which resulted in insufficient altitude and the subsequent failure to maintain clearance with the trees. Contributing to the accident were the trees and the dusk lighting conditions.
- [NTSB CHI08CA251](https://openairdocs.org/ntsb/CHI08CA251.md): Air Tractor AT-301B · Monticello, IA · Accident · Minor injuries · Data collection · Final report · Aug 13, 2008 · N3161D · Substantial damage
  > Poor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…
- [NTSB CHI08CA242](https://openairdocs.org/ntsb/CHI08CA242.md): Schweizer G-164A · Jefferson, IA · Accident · No injuries · Data collection · Final report · Aug 8, 2008 · N73PB · Substantial damage
  > The loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.
- [NTSB CHI08LA037](https://openairdocs.org/ntsb/CHI08LA037.md): Padelt PG37-1 · Hampton, IA · Accident · 2 fatal · Limited investigation · Final report · Nov 16, 2007 · N4448Y · Substantial damage
  > The pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.
- [NTSB CHI07LA312](https://openairdocs.org/ntsb/CHI07LA312.md): Beech B35 · Waterloo, IA · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2007 · N55GW · Substantial damage
  > The pilot's failure to maintain adequate clearance from the trees and terrain during a night visual approach for landing. Contributing to the accident were the pilot's lack of recent night flying experience, the night conditions, and the trees.
- [NTSB CHI07CA196](https://openairdocs.org/ntsb/CHI07CA196.md): Anderson Glasair FT II · Cedar Rapids, IA · Accident · Minor injuries · Data collection · Final report · Jun 29, 2007 · N123JA · Substantial damage
  > The loss of engine power for undetermined reasons during the downwind leg, which resulted in a forced landing. A factor in the accident was the unsuitable terrain encountered.
- [NTSB CHI07FA073](https://openairdocs.org/ntsb/CHI07FA073.md): Cessna 340A · Council Bluffs, IA · Accident · 4 fatal · Field investigation · Final report · Feb 17, 2007 · N111SC · Destroyed
  > The pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.
- [NTSB CHI07LA011](https://openairdocs.org/ntsb/CHI07LA011.md): Cessna R182 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Oct 22, 2006 · N5274S · Substantial damage
  > The fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.
- [NTSB CHI05CA002](https://openairdocs.org/ntsb/CHI05CA002.md): Piper PA-28-180 · Marion, IA · Accident · Minor injuries · Data collection · Final report · Oct 3, 2004 · N7841N · Substantial damage
  > The pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.
- [NTSB CHI04LA185](https://openairdocs.org/ntsb/CHI04LA185.md): Varga 2150A · Winterset, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2004 · N8422J · Substantial damage
  > The inadequate supervision by the certified flight instructor, fuel starvation, visual/aural detection precluded by the certified flight instructor's seat position, and the inadequate crew coordination of both pilots during the instructional flight. A…
- [NTSB CHI04LA085](https://openairdocs.org/ntsb/CHI04LA085.md): Cessna 172R · Dubuque, IA · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 2004 · N105FS · Substantial damage
  > The flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…
- [NTSB CHI02LA240](https://openairdocs.org/ntsb/CHI02LA240.md): Cessna 150H · Dyersville, IA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2002 · N6995S · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.
- [NTSB CHI02LA102](https://openairdocs.org/ntsb/CHI02LA102.md): Cessna 172P · Council Bluffs, IA · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 2002 · N53066 · Substantial damage
  > The student pilot's failure to maintain control of the airplane and the subsequent inadvertent stall. A factor associated with the accident was the student's lack of total experience.
- [NTSB CHI02LA075](https://openairdocs.org/ntsb/CHI02LA075.md): Piper PA-42-720 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Jan 31, 2002 · N66MT · Substantial damage
  > The pilot's failure to maintain the proper glide path during the final portion of the approach. Factors relating to this accident were the low altitude and the utility pole.
- [NTSB CHI02FA009](https://openairdocs.org/ntsb/CHI02FA009.md): Beech 58 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2001 · N7235R · Destroyed
  > The pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.
- [NTSB CHI01LA303](https://openairdocs.org/ntsb/CHI01LA303.md): Cessna 172N · Sheldon, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2001 · N5593E · Substantial damage
  > the in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.
- [NTSB CHI01FA026](https://openairdocs.org/ntsb/CHI01FA026.md): Luscombe 8A · Des Moines, IA · Accident · 1 fatal · Field investigation · Final report · Nov 3, 2000 · N71134 · Destroyed
  > The pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…
- [NTSB CHI01LA022](https://openairdocs.org/ntsb/CHI01LA022.md): Bollinger BD-4 · Hedrick, IA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2000 · N108BC · Substantial damage
  > the pilot not obtaining/maintaining clearance from the fence. A factors was fence.
- [NTSB CHI00LA281](https://openairdocs.org/ntsb/CHI00LA281.md): Piper PA-18-150 · Blakesburg, IA · Accident · No injuries · Limited investigation · Final report · Sep 1, 2000 · N82748 · Substantial damage
  > The pilot failed to add full power during a go around which resulted in descreased airspeed and a subsequent stall. A factor associated with the accident was the airplane stopped on the edge of the airstrip.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=IA&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" = 'IA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=IA

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