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.
Incident 20040613017049IPiper PA46350P · Roanoke, TX(-23) Aircraft PA46 skid off runway at 52F at 1728. No damage to aircraft no injury. Aircraft stopped parallel to runway. Aircraft was cleaned, inspected and flown without incident.Accident 20040613016829AMaule MX7235 · Waukesha, WI(-23) Landed 18 @ ues, loss control & bounced landing in grass east of runway. Aircraft came to rest on nose & main landing gear. End.Incident 20040613015639IAmtr ZENITHCH250 · Brunswick, MO(-23) Pilot states that on June 13, 2004, around 10:00 am CDT, he departed east Kansas city, Missouri, grain valley airport (3GV), enroute to his farm, located 10 miles south of marceline, Missouri. He performed three touch-and-goes at 3GV, departed to mosby,…Accident 20040613012539APiper PA28180 · Anza, CA(-23) On June 13, 2004, at 12:57 PDT, a Piper PA-28-180, N9009J, collided with terrain during and after a hard landing short of runway 24 at lake Riverside airport near Anza, California. Immediately after the hard landing the passenger (a certificated pilot)…Accident 20040613011509AHughes 269C · Denver, CO(-23) The flight of N2062N originated at the jefferson county airport (bjc) with Mr. Larry j. felton as pilot in command. The aircraft made normal approach to runway 17R at the Centennial Airport (apa). During final segment of the approach the pilot…Accident 20040613011499ACessna A185F · Skwentna, AK(-23) On June 13, 2004 at approximately 2000 hours, Mr. Lonnie e. avra, piloting a Cessna A185F N185AV performed a hard landing at an unimproved rough and uneven landing area approximately twelve nautical miles south west of Skwentna, AK. Upon landing the…Accident 20040613010279ACessna 172P · Huntsville, AL(-23) On June 13, 2004, about 1030 CST, a Cessna 172P, N98981, crashed while landing. The pilot was performing a touch-and-go landing and lost control of the airplane. An investigation of the accident site revealed that the airplane touched down on the nose…Incident 20040613009989IPiper PA23 · Tooele, UT(-23) N1321P made an emergency landing on a frontage road near mile post 53, near I-80, Tooele county, Utah. Sheriff's department reports that pilot has a mechanic on the scene.Incident 20040613009869IDoug DC983 · San Francisco, CA(-23) American airlines flight 1907 departed San Francisco International Airport for los angeles on June 13, 2004, and soon after takeoff the crew reported smoke and fumes in the cabin. The crew declared an emergency to air traffic control, turned off the…Incident 20040612020599IPiper PA28181 · Piseco, NY(-23) Aircraft landed long on runway 22 at K09. Pilot was unable to stop aircraft on runway, aircraft ran off the end of the runway, down a slight embankment, across a road before coming to a stop.Incident 20040612020309IPiper PA31310 · Appleton, WI(-23) Right main landing gear would not extend. Circled gbr and burned off fuel. Landed without gear at atw. No injuries.Incident 20040612019879IEMB EMB145 · Rochester, NY(-23) On June 14, 2004 at approx. 1630 LCL, Mr. Thomas hunziker threw a plastic cup of ice and soda at a flight attendant while she was preparing the cabin for landing at Rochester, NY. The incident occurred on Continental express flight 2200 form ewr to roc.…Accident 20040612017729ACessna 172F · Madisonville, TN(-23) On 12 June 2004 at 1315EDT, alan kuntz, pilot of CE-172-F, N8777U, announced over UNICOM that he was downwind for touch and go, rwy 23 at mvl airport. At approx 1655 a pilot approaching mnv spotted N8777U approx. 400 yards from the departure end of rwy…Accident 20040612017659ACessna 172N · Dover, TN(-23) On June 12, 2004 N5153E a Cessna 172N departed Short Creek Airport in Dover, TN. The pilot checked internet radar and saw that thunderstorms were approximately 20 mi. Away and began a departure before the arrival of the weather. The takeoff was to the…Incident 20040612014769ICessna 175 · Berryville, AR(-23) Aircraft made a precautionary landing in a field 16 miles east southeast of Berryville, AR. The pilot reported that the aircraft engine began running rough. He suspected carburator ice and made a precautionary landing in a farm field without incident.…Accident 20040612014109AHspavn HA200 · Pueblo, CO(-23) N611HA, an HA-200 saeta jet departed the Pueblo Memorial Airport at 07:17 am MDT with Mr. Timothy a. nelson as pilot in command and sole occupant. Two still pictures of the aircraft were taken by [privacy data omitted] co-owner and fiance. The first…Incident 20040612013929ICessna 152 · Hollywood, FL(-23) Pilot landed on runway 9R at khwo, during the rollout the aircraft departed the runway and struck a sign adjacent to the runway. Landing gear and associated sheet metal sustained minor damage.Incident 20040612013649IAronca 058B · Joliet, IL(-23) Pilot had just taken off at jot and returned to land on runway 22, a turf runway, because he saw another aircraft flip over. Upon landing, the right landing gear broke off. The runway 22 was saturated with rain water. Pilot stated that he did not land…Incident 20040612013589ICessna U206B · Bay City, MI(-23) Pilot stated that engine sputtered in the turn to final on 36. A go-around was not attempted when aircraft drifted to the right, landing on the grass. Nose gear hit a hole between the runway and taxiway during the roll-out, collapsing the nose gear and…Accident 20040612012389ALuscom 8E · Joliet, IL(-23) Aircraft flipped over on runway 22 when pilot tried to takeoff on turf runway that was saturated with water. When aircraft approached lift off speed, it hit water and flipped over. Pilot suffered minor head injury and was taken by ambulance to hospital.…Accident 20040612012129ADhav DHC2* · Wasilla, AK(-23) On June 12, 2004, at approximately 1800 hours Alaska time, a wheel equipped Dehavilland DHC-2, N105RL veered off the runway at Gattis airstrip and sustained substantial damage after striking a log. According to the pilot, after touchdown he applied…Accident 20040612011609ABbavia 7AC · La Porte, CA(-23) The student pilot collided with the ground after striking some trees in mountainous terrain. Prior to departing the quincy, CA airport, the pilot attached photographic equipment to the aircraft's right hand lift strut. He was flying in the vicinity of…Incident 20040612010439IPiper PA24250 · Kalispell, MT(-23) Pilot landed gear-up in Kalispell, Montana. Tower gave notice via radio on short final that gear was not extended. Pilot did not respond. Mechanic on scene said gear handle was down and gear motor breaker popped. Minor damage. Prop and belly skins.…Incident 20040612008869IPiper PA18150 · Murfreesboro, TN(-23) Pilot landed at Murfreesboro airport as a alternate destination due to weather. Upon landing airplane encountered dramatic shift in wind direction causing aircraft to tip over on its nose. No personal injuries.Incident 20040611027539ICessna 152 · Pompano Beach, FL(-23) On June 11, 2004 at approximately 1115 hrs, the pilot of N953SC reported that the aircraft was experiencing power problems and was attempting to land at Pompano Beach, FL. Aircraft landed at Pompano safely. Anthony aviation of Pompano inspected engine…Incident 20040611015799IAmtr Kitfoxv · Caldwell, TX(-23) Aborted take-off from an off-airport farm pasture causing damage to nose gear, propeller, and sudden stoppage damage to engine. The pilot, who said he was the only occupant, said the nose gear failed at approximately 25 miles per hour during an abort…Accident 20040611015119AAmtr Glastar · Lancaster, TX(-23) On June 11, 2004 @ 1945 CST, a ruehle williams h., Glastar, N106WR suffered a nose gear collapse during landing on runway 13 at the Lancaster Airport in Lancaster, Texas. The airplane was built, is owned and operated by william h. ruehle under the…Incident 20040611014779IEMB EMB135LR · Dallas-Ft Worth, TX(-23) On landing at dfw airport, chqa flight #6490 departed runway 13R to the right and went approximately 250 feet into the grassy area between runway and access road. All passengers exited through the forward entry door, with no injuries occurring. The…Accident 20040611012169AAyres S2RR1340NORM · Eagle Lake, TX(-23) Substantial damage to aircraft following a failure of the left main landing gear support tube. During takeoff on runway 35, the aircraft drifted left and departed the runway at the 2600 foot mark. The aircraft went into the mud, collapsed the left main…Accident 20040611011819APiper PA38112 · Jerome, ID(-23) Pilot landed N2579N, a PA-38 in a soft potato field as a result of fuel exhaustion. According to the pilot, he attempted to keep the nose off of the ground after landing as long as possible. Since the field was very soft, the nose gear stuck into the…Incident 20040611010459ICessna TU206G · Provo, UT(-23) N878AH, departed mesquite, Nevada (67L) to salt lake city international (slc), flying at 11500' when the engine made a noise and then lost oil pressure. The pilot found a gravel road and landed without incident. One pilot and 4 passengers, no injuries…Accident 20040610035549ACessna 172P · Haworth, NJ(-23) The pilot was interviewed at the scene and stated the following: "aircraft departed westerly rhode island bound for caldwell NJ. After 45 minutes flight time, and at an altitude of 1500 ft. the engine lost all power. The pilot notified NY approach. They…Incident 20040610017289IPiper PA24250 · Birmingham, AL(-23) On June 10, 2004, N7232P made a gear up landing at the Birmingham international airport. The pilot reported that he was on an ILS approach to rw 24 with the gear down when he lost complete electrical power and made an emergency landing at the Birmingham…Accident 20040610016759AScwzer G164B · Hope, ND(-23) Aircraft contacted a tree branch while spraying along a shelter belt causing substantial damage to the left wing of the aircraft. Pilot stated that the branch was sticking out a few feet beyond the rest of the trees and he misjudged the distance.Incident 20040610015829ICndair CL6002B19 · New Orleans, LA(-23) Following landing the pilot turned onto taxiway e and heard a loud grinding noise coming from the nose gear area. The pilot stopped on the taxiway and called the tower and asked for a maintenance crew to investigate. The maintenance crew found the…Accident 20040610015589AMooney M20C · Princeton, MO(-23) Aircraft departed m graham clark airport (plk), for a 10 minute local flight to table rock airport (MO32). The pilot stated that as he crossed the runway 9 threshold at MO32, the aircraft drifted sharply to the left. The pilot applied full power and…Accident 20040610015179AAyres S2R · Needville, TX(-23) On June 10, 2004, at 0830 local a rockwell international S-2R thrush serial number 5013R registered as N4968X crashed in a field near Needville, Texas. The pilot reported to the police that he had an engine fire and landed the aircraft as soon as he…Incident 20040610012369IBeech D35 · San Jose, CA(-23) On June 10, 2004, at approximately 1258 PDT, a Beechcraft bonanza, N3417B was enroute from watsonville airport (wvi) to grass valley airport (O17). At about 5 miles east of Reid-Hillview airport (rhv) the pilot felt a vibration in the engine. The pilot…Accident 20040610011569ACessna 172N · Hillsboro, ND(-23) The pilot of this aircraft, operating under 14 CFR part 91, landed to the south at the Deck private air strip just north of Hillsboro, ND. The wind was from the east south-east, gusting from 15 to 21 knots. Weather was reported as visual flight rules…Incident 20040610010059IBoeing 737347 · Salt Lake City, UT(-23) Delta flight 1640 lost the tread from the right inboard main landing gear tire recap. On rotation the crew felt a vibration. Shortly after that there was a hydraulic pressure warning, a and b system, then the master caution came on. The crew manually…Accident 20040610009709ABell 206L1 · Grand Canyon, AZ(-23) This was an occurrence wherein a passenger jumped from a helicopter during a Grand Canyon tour. The sheriff's department declared it a suicide.Incident 20040609015319ISaab 340B · Chicago, IL(-23) Aircraft had arrived from des moines, IA on flight 3472 and was being prepared for the outbound flight 3840 to south bend, IN. During the baggage loading operations one of the ramp personnel approached the aircraft towing a baggage cart, from the rear…Incident 20040609015089IBeech 58 · Cincinnati, OH(-23) Aircraft N6577S was cleared for touch and go on runway 21L. As the aircraft touched down and began the rollout, the landing gear collapsed, sending the aircraft down the runway on its belly. The aircraft never left the runway, coming to a stop at…Incident 20040609014759IMaule M5235C · Richland, WA(-23) On landing rollout the right gear leg collapsed, breaking in the middle, damage was limited to wing tip scrapes, bent wing struts, bent gear leg, and localized fairings, bent propeller, there were no unusual attitude maneuver type marks in the gravel…Incident 20040609014709IPiper PA28180 · Oakland, MD(-23) During flight, pilot experienced total engine failure. Pilot was unable to reach Garrett County Airport (2G4) and was forced to land in a field about 3 or 4 miles from the airport. Investigation found #2 piston pin was pulled from the piston, causing…Incident 20040609014139IBeech E18S · New York, NY(-23) On or after landing right main landing gear link assembly ("scissor") failed allowing wheel assembly to rotate. As aircraft slowed it left runway near taxiway ending up stopped on the adjacent pavement. No damage to airport equipment.Incident 20040609012759ITmpson Naviona · Bedford, MA(-23) Pilot reported abrupt power loss after takeoff and gear retraction. Pilot elected to extend gear and land on runway remaining. Only nose and right main gear extended to the locked position prior to contact with the runway. Left main remained partially…Incident 20040609012489ICessna 208 · Canon City, CO(-23) According to the pilot, N9652F departed the Fremont County Airport (1V6) at approximately 1730 MDT with a load of approximately 10 sky divers. The aircraft climbed to 17,500 MSL at which time the skydivers departed the aircraft. The photographer[privacy…Accident 20040609012399AAmtr RV6 · Cloverdale, CA(-23) On June 9, 2004, N621BP, an experimental RV-6 airplane, impacted the ground thirty feet short of runway 14 at Cloverdale Municipal Airport (O60). The aircraft skidded approximately fifty feet and came to rest on the left edge of runway 14. The cockpit…Incident 20040609011709IRobsin R22BETA · Kingsburg, CA(-23) On 06-09-04, Mr. Moriarty was acting as pilot in command of a Robinson R-22 helicopter engaged in sight seeing near Kingsburg, CA, along the Kingsburg river. He stated that he decided to drop down and hover near and look at a house under construction…