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 20040531015409IBoeing 727225 · Indianapolis, IN(-23) On 5/31/04 a B-727-225 enroute to ind encountered engine problems on #2 & #3 engines. The crew reported, on flight log# 15051, #2 engine had a compressor stall in which the engine power had to be reduced to idle. In addition, #3 engine had an overheat…Incident 20040531014909ICessna TU206B · Boulder, CO(-23) Jumpers did not land in drop zone while performing an exhibition jump into the stadium at Boulder, Colorado. One landed on roof of nearby building, another in a tree outside of the stadium and another in the stands. The news reported that a spectator…Incident 20040531014749ICessna 172P · Beatrice, NE(-23) The aircraft was being refueled. The wind increased substantially. Refueling was stopped. The pilot attempted to taxi the aircraft to the tie down area. While taxiing, the wind lifted the tail and the propeller struck the concrete. METAR reported the…Incident 20040531014719ICessna P210N · Willmar, MN(-23) On June 2, 2004 the msp FSDO was notified that N210GU landed gear up at the Willmar, MN airport. The caller did not know particulars only that he heard this event occurred. After some research on June 22, 2004 the pilot of N210GU was contacted and…Accident 20040531012689AUnivar 1082 · Susanville, CA(-23) Stinson 108-2, N9816K, took off from Spaulding Airport (1Q2) runway 16 and impacted a small tree located approximately 300 yards beyond the south end of the runway, about 120 yards to the right of runway centerline. One witness reported the pilot…Accident 20040531011169AHall LANCAIR4P · Vermontville, MI(-23) Lancair ivp N707SH, departed ypsilanti, MI (9MI0) with two passengers and baggage on board. Witnesses saw the aircraft spiraling toward the ground and heard a loud thud at approximately 1345 EDT in Vermontville, MI (eaton county) lat/long N42 37.793,…Accident 20040531011159ABoeing B75N1 · Ft Mcdowell, AZ(-23) From witness statements obtained by ft. Mcdowell tribal police it appears as the pilot was doing aerobatic maneuvers and after a barrell roll the aircraft did a stall/spin and crashed on the mountain side.Incident 20040531010539IBoeing 757251 · Anchorage, AK(-23) Northwest gate agent opened aircraft door 1L, while flight attendant still had her hand on the handle. The flight attendant sustained a fractured wrist.Accident 20040531010199AAyres S2RRESTD · Beaver, UT(-23) Power failure during cruise flight. Emergency landing resulted in substantial damage to the aircraft. There were no injuries to the pilot.Accident 20040531009849APiper PA28R180 · Columbia, CA(-23) On 05/31/2004, at 1056 hours PDT, a Piper PA-28R-180 model aircraft, N7626J, collided with level terrain following a loss of engine power after takeoff from runway 17 at Columbia Airport (O22), sonora, CA. The pilot/owner operated the aircraft under the…Accident 20040531009429ACessna 172P · Mesquite, TX(-23) At approximately 13:30, 31 may 2004 a Cessna, model 172, registration N98885, was conducting flight training at Mesquite Hudson (khqz) airport. The aircraft, flown by the student, entered the pattern 45 to the downwind. The student reported he…Accident 20040531008359ACessna 177B · Grand Canyon, AZ(-23) The pilot stated he had gone around on his first landing attempt due to a crosswind. On his second attempt, he touched down and immediately lost control of the airplane in a gusty crosswind. He ran off the runway to the right going inverted in a ditch.Accident 20040531008139ACessna 172M · Levelland, TX(-23) On may 31, 2004, at approximately 1040 CDT, a student pilot was attempting solo flight touch-and-go at the Levelland Municipal Airport, Levelland, Texas. He successfully made one touch-and-go, but on the second attempt the aircraft ran off the left side…Accident 20040530017589ACessna 310 · North Myrtle Be, SC(-23) Aircraft was on an IFR flight plan into mrytle beach airport (cae), SC. On a three mile final to runway 23 the aircraft started losing altitude and made an emergency controlled crash landing in the intercoastal. All four survived the landing and exited…Incident 20040530011939IPiper PA28180 · New Orleans, LA(-23) Aircraft's engine quit on takeoff. Instructor pilot was able to turn back to airport and land without injury to himself or student pilot. There was no damage to the aircraft.Accident 20040530010479ACessna T210M · Santa Rosa, CA(-23) Aircraft departed lake pillsbury airport (IQ5) direct to Santa Rosa (sts). Pilot observed that aircraft main landing gear had failed to extend during final approach to sts. Pilot cycled gear numerous times and noted that a safe gear indication was not…Incident 20040529033629IRochester, NY(-23) On may 29, 2004 at approx. 1029 LCL, [privacy data omitted] appeared to be intoxicated and was unruly when he left his seat and went to the lavatory during descent into Rochester, NY while on board jetblue flight 20. Local law enforcement extracted…Incident 20040529020019IBeech S35 · Lewisburg, WV(-23) Nose gear collapsed on landing rollout. [privacy data omitted]Incident 20040529019949IMooney M20C · Atlantic City, NJ(-23) Pilot was making the approach to runway 20 at aiy (Atlantic City muni/Bader field) for landing. As the aircraft was in a flare to land the landing gear retracted back into their wells. The aircraft settled on the runway. The prop hit the runway and…Incident 20040529019869ICessna 210G · Buffalo, NY(-23) On may 29, 2004, at 1122 EDT, a Cessna 210G, N5838F, operated by reginald e. miller, diverted to Buffalo niagara international airport after experiencing smoke in the cockpit. A landing was accomplished and fire and rescue responded. The aircraft taxied…Incident 20040529019729IPiper PA28161 · Poughkeepsie, NY(-23) The pilot was a student flying his first cross country and was attempting to land on runway 06 at kpou. The student reported that while landing a gust of wind blew the aircraft to the right side of the runway causing the aircraft to strike a runway edge…Accident 20040529017209ACessna 172M · Worcester, MA(-23) While landing on runway 29 at Worcester airport (orh) the pilot lost control of aircraft and exited runway 29 1300 feet down and to the left in a grass area. Marks on the ground indicate that both left and right wings made contact with ground as did the…Accident 20040529017199AMooney M20R · Lebanon, NH(-23) Pilot [privacy data omitted] flying a Mooney M20R N532WM, was attempting to land on runway 04 at warren/sugarbush airport 0B7 in Vermont at approximately 1130 hours. The pilot experienced crosswinds, and loss of lift approximately 10 feet above airport…Accident 20040529016539ACessna 170B · Auburn, CA(-23) During the landing rollout, the pilot allowed the airplane to drift to the right side of the runway causing the right gear to strike the runway light and the left wing tip to strike the ground. The airplane came to a stop with damage to the gear and the…Incident 20040529011949ICessna 150L · Shreveport, LA(-23) Aircraft's engine started running rough several miles away from Shreveport Regional Airport (kshv). Engine quit 3 miles from airport, while pilot was on final for runway 14. Pilot was able to land in the grass adjacent to the runway.Accident 20040529011859AAmtr HP11A · Cherry Valley, AR(-23) On may 29, 2004, at approximately 1400 CDT, glider HP11A, N678P, experienced substantial damage due to a hard landing at Cherry Valley, Arkansas. The private pilot stated that the aircraft stalled while attempting to land. The glider 'dropped like a…Accident 20040529011839AChris A1 · Luling, TX(-23) During takeoff, the aircraft entered a steep ascent followed by a near vertical descent, and ground contact.Accident 20040529011539ANamer P51C · Red Wing, MN(-23) During airshow pilot reported loss of engine power. During emergency landing, pilot attempted landing southeast of the airport in a residential area. On landing the aircraft struck a tree causing substantial damage to the aircraft. Note: will amend…Accident 20040529011479AAmtr Sportbiplane · Mazon, IL(-23) Owner/pilot was test flying the aircraft because of an oil pressure problem. Pilot took off from his back yard strip, entered into a right climbing turn, but the aircraft continued to roll over and plummeted into the ground inverted from about 300 feet.…Accident 20040529011079ABeech P35 · Havre, MT(-23) On may 29, 2004, at approximately 1:10 p.m. mountain daylight time, a Beech P-35, registered as N7DR, experienced a loss of engine power shortly after take-off from Havre, Montana. During the emergency landing, the aircraft was substantially damaged. No…Accident 20040529010509ACessna 170B · Anchorage, AK(-23) The student pilot was demonstrating a wheel landing to the DPE for his private pilot certificate and lost control and ground looped the a/c.Incident 20040529009919IUnivar 1082 · Santa Ana, CA(-23) On 5/29/2004, at approximately 1435 hours, a banner tower dropped its banner short of the airport this caused the banner to fall on a car on the 405 south freeway access road to the Santa Ana airport. The pilot had been flying for approximately two…Accident 20040529009839ABeech A36 · Hollister, CA(-23) During takeoff on runway 24 at Hollister airport N6797Y became airborne, turned left and subsequently struck the ground flat under partial or full power. Ground markings showed the aircraft's ground path to be approximately forty-five degrees from the…Accident 20040529009819AAmtr BD5 · Goodyear, AZ(-23) Pilot reported that during cruise flight, he detected a momentary vibration and then a complete power failure. Pilot was unable to perform a restart and proceeded to make a forced landing. Pilot stated that he landed on an old abandoned airstrip 7 miles…Accident 20040529009019ALkheed TV2 · Calhan, CO(-23) Flight was on instrument flight plan enroute from sln to den. Airplane was fueled in sln to all tanks full. This was more than enough fuel for flight and extra in case of any weather deviations. On arrival into den fuel lights came on advising that fuel…Accident 20040529009009ACessna 172M · Vernonia, OR(-23) On 05-29-04, N5440H a Cessna CE-172 landed fast on rwy 260 at Vernonia, OR (05S) and ran off the end of the wet grass strip. Due to the wet grass the pilot had no braking action and the aircraft went off left side of the grass strip and hit a fence…Accident 20040529008809APiper PA38112 · Carthage, MS(-23) The pilot did not have a log book endorsement from his CFI to solo to the Carthage airport. Surface winds in the surrounding area at the time were greater than 10 knots. The CFI did not endorse the pilot to fly with surface winds greater than 10 knots.Incident 20040529008599IAirbus A320232 · Oakland, CA(-23) Oakland international airport air traffic control reported on may 29, 2004 that jetblue airways flt 94 departing from Oakland enroute to jfk, struck at least five geese departing runway 29 @0707 PDT. The aircraft returned to the Oakland international…Accident 20040528018519AVizola CALIFA21 · Starkville, MS(-23) The pilot in command of the capronin glider saw the weather getting worse and made the decision to land. During descent from 8500 feet to 3000 feet the canopy completely fogged over leaving the pilot with no visibility, except out of a 2X2 side vent…Accident 20040528016999ACessna T206H · Lamont, IL(-23) Pilot reported loss of power to midway tower. Attempted to land in a field approximately 100 yards west of the impact area. Witnesses reported that the propeller was turning and the pilot was trying to restart the engine.Incident 20040528011359IAmtr TURNERT40A · Hammond, LA(-23) The pilot was on the first flight of the newly constructed amateur-built aircraft. The pilot stated that he was a "little high" on his landing approach and landed the aircraft hard. During the landing the left main wheel separated from the landing gear…Incident 20040528011339ICessna 170B · Laurel, MT(-23) Pilot and sole occupant stated that pilot had been doing touch-and-go's on runway 04. The pilot stated that the wind was approximately 050-060 degrees at 13 knots. During second landing, he stated the right wing started to rise. He could not correct…Accident 20040528010169AAerosp AS355N · League City, TX(-23) On may 28, 2004, at 0935 local time an American Eurocopter AS-355-N, serial number 5569, registered as N355CV crashed near League City, TX. The aircraft attempted an autorotation in a field after the pilot noted a loss of engine power in cruise flight…Accident 20040528009829AAmtr Avidbandit · Paso Robles, CA(-23) On may 28, 2004, at 1330 pacific daylight time, an experimental, amateur-built wilson avid airplane, N55368, impacted grapevines during a forced landing following a loss of engine power near Paso Robles, California. The second leg of a cross-country…Incident 20040528009279IAmtr Challengerii · Hot Springs, AR(-23) Mr. Tobin stated that on 28 may 2004, he departed the Hot Springs airport (hot) at 6:15 pm flying west to lake hamilton to locate an empty area where he intended to land. He found an area with no boats or people in sight and set up to land. Mr. Tobin…Incident 20040528008669ICessna S550 · Pittsburgh, PA(-23) Telephone interview with the pilot Mr. Andrew e. landdeck ATP 2702210, stated the aircraft was cruising at 31,000 feet when the crew heard the cabin door seal start to leak, followed by the cabin rate climbing at 1000 fpm, and requested descent, passing…Incident 20040527022729IBell 47G · Harrisburg, PA(-23) During landing to runway 26, aircraft was descending too fast when wind shifted to the tail. Pilot stated that he contacted the runway hard. Pilot repositioned aircraft to ramp. During post flight inspection it was discovered that the aft cross-tube was…Accident 20040527018149APiper PA34200T · Cleveland, TX(-23) On June 27, 2004, at 1156 central daylight time, a Piper PA-34-200T twin engine airplane, N2948S was destroyed during an emergency landing to a field near Cleveland, Texas. The commercial pilot, the sole occupant, sustained minor injuries. The airplane…Accident 20040527017189AAmtr Avidhauler · Fitchburg, MA(-23) Mr. Bramich stated that he arrived at the airport at 12:30 pm on the afternoon of 5-27-2004. He completed a preflight on aircraft N5139W, his experimental airplane. This check included flight controls, fuel level and caps, and visual check of elevator…Incident 20040527014889ICndair CL6002C10 · St Louis, MO(-23) STL-N367CA-FLT5672-DSM enroute to atl-preliminary incident report, crew reported an engine out to ATC, aircraft landed stl without incident. #2 engine vibration indicator at 2.4 during cruise. Crew declared emergency and diverted to stl. Aircraft landed…