FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Accident 20030602011659AEMB EMB120ER · Denver, CO(-23) On June 2, 2003 at approximately 17:40 local time, great lakes airlines flight 5120 had landed at Denver International Airport and was taxiing into parking at the east end of concourse a. great lakes airlines ramp marshal was directing N299UX into zone…Accident 20030602011339ACessna 172P · Gainesville, TX(-23) On June 2, 2003 at 1810 gmt, a Cessna 172P, N51611, owned by delta aeronautics, inc., c/o k.w. mcloud, 151 meacham airport cir., bldg. 4N, fort worth, Texas, 76106, had an accident at the Gainesville Municipal Airport (gle), Gainesville, Texas, during a…Incident 20030602010609IPiper PA34200T · Baxley, GA(-23) The aircraft departed from (ksyi) shelbyville, TN enroute to (kbhc) Baxley, GA. The pilot elected to fly a standard pattern with a 45 deg downwind entry for runway 8. The pilot stated he reduced airspeed and placed the gear handle in down position. At…Incident 20030602010359ICessna 560XL · Portland, OR(-23) N561GR departed runway 28R. Part of the left engine upper cowl separated and struck the left horizontal stabilizer. Runway 28R was closed for debris removal/inspection. Pilot was advised by ATC of ejected cowling. Pilot initially requested to burn fuel…Incident 20030602009579ICessna 172RG · Atlanta, GA(-23) Aircraft departed pdk upon his return to the pdk airport Mr. Mccarter was cleared to land on runway 2L by the pdk tower. The aircraft was landed approximately 1/3 of the way down the runway and Mr. Mccarter was unable to bring the aircraft to a stop or…Incident 20030601032839ICessna 177A · Burlington, WI(-23) On June 01 2003 a CE-177 N30302, operated by richard j spletzer, impacted a swale while taxiing, at Burlington airport Burlington WI. The pilot stated, after landing on runway 19 he proceeded to taxi. At the end of the runway he turned the aircraft to…Accident 20030601027769ABeech 58 · Big Bear, CA(-23) A Beech 58, N18142 sustained substantial damage when the gear collapsed upon landing at Big Bear City Airport, Big Bear city, California.Incident 20030601020559IAmtr VELCITY173RG · Juneau, WI(-23) On June 01, 2003 at approximately 1100 CDT, a velocity 173RG (experimental) operated by joseph j. schiferl landed gear-up at Dodge County Airport Juneau WI. During approach to land, the pilot stated that he forgot to lower the gear and landed gear-up.…Incident 20030601019119ICessna R172K · Detroit/Grosse, MI(-23) The pilot (charles d. gillan) stated that while on base leg, he changed his mind from landing on rwy 4, to do a "touch and go" on the water to the right side of that rwy but had already completed the landing checklist (to rwy 4). He neglected to retract…Accident 20030601018789AMooney M20S · Chicago/West Ch, IL(-23) Flared too high in landing and bounced twice. Unable to control aircraft during go-around attempt. Ran off runway.Accident 20030601016049ACessna 172N · St Petersburg-C, FL(-23) On June 1, 2003, about 1032 eastern daylight time, a Cessna 172N, N9758G, registered to four fox air inc., and operated by an individual, impacted with an airport sign during the takeoff roll at the st. Petersburg/Clearwater international airport,…Incident 20030601014519ICessna R182 · Houston, TX(-23) Private pilot, while performing touch and go landing for aircraft checkout, inadvertently moved landing gear handle instead of flap handle. Nose gear partially retracted and aircraft settled onto nose cowling causing minor damage to propeller and…Incident 20030601014489IBeech F33A · Lufkin, TX(-23) Gear collapsed after landing on runway 25 at the lfk airport-no injuries to either of the two occupants and only incident damage to the aircraft. Pilot said elec system slowly failed on this one hour local test flight following replacement of the…Accident 20030601014019ACessna 152 · Owensville, MD(-23) Pilot and non-rated passenger. Completed preflight and run-up without any problems noted. Performed a short-field takeoff. Approximately 50% to 75% of the way down the runway (by the pilot's estimate) the pilot felt he was not going to have enough speed…Accident 20030601013969ACessna T210N · Tribune, KS(-23) On June 1 a Cessna T210N with one pilot and three passengers departed from pagosa springs, co (2V1) at approximately 7:00AM (MST) en route to osborne, KS (K75). Approximately one hour and forty minutes into the flight the plane experienced an engine…Incident 20030601013909IPiper PA28R200 · Bloomington, IN(-23) Aircraft N28UP was being flown by PIC edward rick mize (PIC) who was participating in the wings weekend program conducted at greenwood, IN airport (hfy). Pic's company owns N28UP. Douglas jenkins (CFI) was providing non-compensatory instruction to PIC.…Accident 20030601011709ARaven S77A · Cottage Grove, MN(-23) While on balloon sightseeing flight, the winds increased and pilot decided to land in a park. Balloon landed hard but stayed upright. One 84 year old passenger broke rib by being run into by another passenger. There was no damage to balloon. Counseled…Accident 20030601011029AUnivar 1081 · Jenison, MI(-23) Pilot's statement: "came in for landing, normal configuration, touched runway. At that second, lost control. Aircraft veered to left, left wing came up, right wing touched ground, right gear broke & prop touched ground."Accident 20030601010579ARobsin R22BETA · Las Vegas, NV(-23) During a solo flight in the southwest practice area at las, helicopter struck guide wire coming off power line poles which wrapped around the swashplate. Lost tail rotor effectiveness and went into autorotation. Upon landing, the helicopter spun around…Incident 20030601009819ICessna 172N · Ramona, CA(-23) Airman had a verbal altercation with another pilot after landing. Inspector talked to both pilots and resolved issues on the spot. No follow up action planned. [privacy data omitted]Accident 20030531037899AAviat PITTSS2A · Grand Prairie, TX(-23) On may 31, 2003, approximately 1030 central daylight time, an aerotek pitts S-2A single-engine aerobatic bi-plane, N97DW, sustained substantial damage following a partial in-flight breakup while maneuvering near Grand Prairie Municipal Airport (gpm),…Incident 20030531024259IPiper PA38112 · Brookshire, TX(-23) At 4500 feet, enroute to fredericksburg, Texas, lost power. Thereafter could not develop power above idle. On landing in field, struck fence post causing minor damage to wing root fairing. Mechanic did engine run up and discovered one magneto…Accident 20030531016809ABeech 35B33 · Inyokern, CA(-23) On 05/31/2003 N5FL landed gear up on runway 20 at Inyokern Airport, kiyk. The pilot in command of the Beech BE-35-B33 was thomas w. parlet. In a telephone interview and a written statement provided by Mr. Parlet he states that he made a normal overhead…Incident 20030531014449ICessna T310R · Texarkana, AR(-23) On may 31, 2003 at 1530CDT, a Cessna model 310R, N1781E, made a nose gear up landing on runway 04 at Texarkana regional airport (txk), Texarkana, AR. The multi-engine aircraft sustained minor damage to the undercarriage. The pilot reported that he heard…Accident 20030531013769AAmtr Kitfoxv · Jerome, AZ(-23) On may 31, 2003 approximately 0720, mountain standard time, a gray/kitfox, N111BM, owned and operated by a Mr. William mosley, lost control and collided with terrain while maneuvering in the vicinity of Jerome, Arizona. The aircraft was being operated…Accident 20030531012519ACessna 172M · Conroe, TX(-23) Aircraft departed on runway 14 and during the climb out the pilot stated he heard the stall warning horn sound and stated he attempted to lower the nose and apply right rudder. The aircraft continued to drift to the left of the runway and when they were…Accident 20030531012289ACessna 425 · Pueblo, CO(-23) On may 31, 2003, subject aircraft departed page AZ enroute denver centennial (apa). The flight was being conducted under title 14 CFR, part 91. The private pilot and his commercial rated passenger were not injured nor was the additional person seated…Incident 20030531012049IPiper PA32300 · Denver, CO(-23) While enroute from Denver Centennial (apa) to pueblo co (pub), approximately 7 miles south of apa, pilot contacted ATC to inform that his engine was failing and that he was landing in an open field. No damage was incurred by the aircraft. Pilot switched…Accident 20030531011699ACessna 182Q · South Lake Taho, CA(-23) Pilot's statement: dear Mr. Roche, thank you for your time and evaluation of the incident at tvl on Saturday, 05-31-03. The following is the statement that will be submitted to NTSB per part 830: civil air patrol (cap) was assigned an air force mission…Accident 20030531011349APiper PA28150 · Price, UT(-23) During a touch and go on runway 36, the pilot rotated at a low air speed for the wing conditions, which were gusting up to 38 KTS at 250 degrees to avoid a flock of birds. The pilot elected to land again due to the fact the aircraft wasn't climbing and…Accident 20030531011319ACessna 150D · Dillon, MT(-23) Pilot stated he encountered a gusty crosswind on takeoff from his Private dirt airstrip, lost directional control, went off the runway, through a fence and into the adjacent field where the airplane went over on its back. Pilot was not injured. Aircraft…Accident 20030531011209AAmtr Glasairshii · Riverside, CA(-23) On 5/31/03, at approximately 10:10 am, glasair, experimental category aircraft, impacted terrain after take off at the Riverside Municipal Airport. The sole occupant was fatally injured. Flight hours for make and model, and hours flown last 90 days were…Accident 20030531010929AScwzer G164B · Superior, NE(-23) On may 31, 2003 at approximately 17:30 CDT a Grumman 164B, N48597 operated by blackstone aerial spraying LLC departed the Superior municipal airport for a FAR 137 aerial application in riverton, Nebraska. The aircraft departed runway 14 turning east…Accident 20030531010749ABeech 95C55 · Canby, OR(-23) Attempted takeoff with fuel selectors on aux-tanks. After airborne, both engines lost power landing gear was retracted. Aircraft landed wheels up in wheat field adjacent to runway and slid back towards center of runway. Aircraft came to rest on right…Accident 20030531009959AAmtr Quickie · Alexander City, AL(-23) On may 31, 2003, at approximately 13:00 hours local time, Mr. James annable, who was the pilot in command, departed Alexander City airport in an amateur homebuilt aircraft, N389Q. After departure Mr. Annable stated the aircraft was unstable, the engine…Accident 20030530037259ADhav DHC2MK1 · Salmon Lake, AK(-23) Aircraft flipped over on its longitudinal axis upon touchdown on water surface at Salmon Lake: pilot admitted to NTSB that he had forgotten to retract the landing gear into the floats prior to landing. The landing gear striking the water prior to floats…Incident 20030530017339ICessna 750 · Newburgh, NY(-23) This was an operational check flight (ocf) approved by Mr. Breant owens and released by mindi from eja dispatch. The ocf was on the pitch feel fail system. At 95 to 100 KTS a red cas "no take off" warning annunciator and a red master warning came on.…Incident 20030530015009IPiper PA28140 · Nashville, TN(-23) After takeoff and at approximately 250 feet altitude, RPM reduced from 2400 to 1800 RPM. Engine began missing. Since there was an open field available and parallel to the airport, pilot opted to land in the field. No aircraft damage. Aircraft was towed…Accident 20030530014209ANamer T28A · Houston, TX(-23) The pilot reported that after a normal landing at about 70 knots he felt a high frequency vibration from the nose landing gear. He then raised the nose and the vibration went away. After slowing to approx. 20 knots the vibration reappeared but at an…Accident 20030530013819ACessna 172N · Orangeburg, SC(-23) Aircraft experienced loss of engine power while in flight. Partial power was restored and pilot attempted to return to departing airport, Orangeburg municiple, SC. On final the aircraft experienced a complete loss of engine power, and an emergency…Accident 20030530013199ADenisw Cozy · Kailua-Kona, HI(-23) The pilot stated that shortly after takeoff and during the climb his engine abruptly quit. He was able to land on the remaining runway; but exited off to the side of the runway into a lava pit. As part of this accident investigation and a review of Mr.…Incident 20030530012889IMrchti S20522R · Houston, TX(-23) Pilot made a gear up landing on rwy 17 at sugarland regional airport (sgr). Pilot stated he was bringing the aircraft to this airport for radio work and was using a handheld radio to contact the tower and was distracted enough trying to contact and…Incident 20030530011149ICessna T210N · Westminister, MD(-23) Aircraft was picked up from the maintenance facility after completion of an annual inspection. After a 30 minute flight the oil pressure dropped to 0. Soon after the engine stopped. The pilot landed at the closest airport which was Westminister MD.…Accident 20030530011009ACessna 172 · Republic, WA(-23) Pilot rudy ohlund and ferry county, WA undersheriff matthew lane were conducting an air search and rescue operation under part 91 for a missing person in conjunction with ground searchers when the aircraft stalled and spun into the ground along a three…Accident 20030530010949AHiller UH12E · Cheyenne, WY(-23) Pilot was spraying railroad right-of-way and then made a cyclic climb with a pedal turn. This pedal turn placed the helicopter in a down wind condition with the winds at about 20 KTS. The aircraft struck the ground hard and rolled onto its right side.Accident 20030530010779APiper PA44180 · Livermore, CA(-23) N3060K, a PA-44, departed Livermore airport, Livermore, CA on an IFR flight plan with a destination of mather field, sacramento, CA. The instructional flight was conducted in actual IMC conditions. The aircraft was cleared the Livermore one (SID) with…Incident 20030530010679ITcrafk DCO65TCRAFT · Everett, WA(-23) Pilot and witness verbal statements to FAA indicate pilot lost control of aircraft after landing. Application of brakes caused airplane to go up on its nose. Engine sudden stoppage and prop damage. Pilot exited aircraft unhurt under his own power.Accident 20030530010509ABbavia 7GC · Casper, WY(-23) During landing rollout the aircraft was substantially damaged when the pilot lost control and the aircraft ground looped.Accident 20030530010449AAerovd L39 · New Jerusalem, CA(-23) PIC departed byron airport, California at approximately 1845 local on may 30, 2003. Purpose of flight was to practice flight maneuvers at the aerobatic box located at New Jerusalem airport. While conducting alerion roll maneuvers over the airfield the…Accident 20030530009939ABeech T42A · Forest, MS(-23) Aircraft landed gear up on runway 16 at g.v. montgomery (2M4) forrest, MS. Pilot stated he forgot to put the landing gear down. Checklist available but not used.