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 20041024034749IBac AVRO146RJ85A · Minneapolis, MN(-23) Mes flight 3690 departed msp on 10/24/2004 at 0800. The pilot not flying (captain) failed to set the pressurization system for takeoff, climb, and cruise. The aircraft did not pressurize causing the oxygen masks to automatically deploy at 13,500 feet…Accident 20041024032519AAviat PITTSS1S · Liberal, KS(-23) Aircraft was observed performing aerobatic maneuvers and was observed entering an inverted descending spin. Pilot was unable to recover and the aircraft impacted the ground in an inverted attitude.Incident 20041024029209IBeech D17S · Denver, CO(-23) Pilot was taking a flight test for the renewal of his flight instructor certificate in a Beech staggerwing under 14 CFR part 61. On the final landing, rw 02 at bjc, the aircraft touched down. According to the pilot after touchdown he noticed the FAA…Incident 20041024028719IBeech C24R · Marked Tree, AR(-23) On October 24, 2004, at 1600 hours CST, a Beechcraft BE-23-C24R, N118GB, sustained minor damage when, upon landing, the nose wheel strut failed and departed the airplane. The airplane skidded down the runway resulting in a bent propeller, damaged…Accident 20041024028199ALear 35A · San Diego, CA(-23) On October 24, 2004, a Lear 35, N30DK departed brown field (sdm), San Diego at 0025 hrs. He departed runway 8 and contacts socal radar stating that they departed sdm squaking VFR with the IFR to abq. N30DK was radar identified and issued a heading of…Incident 20041024027389IAmtr RV9A · Stilwell, KS(-23) The pilot decided to fly the homebuilt two-place airplane for the first time to put some hours on it. The airplane had not been inspected by the FAA, nor had it been issued an airworthiness certificate. The engine failed shortly after takeoff, and the…Accident 20041024027329ACessna P206B · Taylorville, IL(-23) This aircraft operated by mid america sport parachute club, inc. of Taylorville, IL. Was conducting parachute operations over the Taylorville airport at approximately 14:40 hours on 10-24-04. One jumper experienced a premature deployment of his main…Accident 20041023034879ACessna 152 · Mesa, AZ(-23) Student pilot reported that on landing during touch and go's, the aircraft drifted to the left side of the runway. The pilot reported that he was unable to correct the drift to the left and the aircraft exited the runway. The pilot also used the brakes…Accident 20041023031199APiper PA28140 · Lehighton, PA(-23) Pilot was making first landing of the day at Lehighton (Jake arner airport, (22N), on runway 8. His approach to landing was a little high, but all other factors were normal including airspeed. The aircraft landed hard on the main landing gear and…Incident 20041023030899IEMB EMB145LR · Philadelphia, PA(-23) After take off from runway 9L at phl to cmh flight attendant notified captain that fuel was leaking from left wing. Captain visually verified fuel leak by looking out his window. Captain declared an emergency with ATC because of the fuel leak and…Incident 20041023030869IPiper PA28R201T · Saluda, VA(-23) Pilot stated that he forgot to extend the landing gear and the automatic gear extension system was in bypass.Accident 20041023028949ABeech F33A · Flat Rock, NC(-23) On October 23, 2004, at 1100 eastern standard time, a Beech bonanza F33A, N18303, registered to air equipment, inc. and operated by a private pilot, collided with the ground in the vicinity of Flat Rock, north carolina. The personal flight was conducted…Accident 20041023028409ANamer HARVARD2 · Gilbert, SC(-23) On October 23, 2004, the pilot in command, a commercial pilot, was operating N92871 on a FAR part 91 flight in the vicinity of Gilbert, SC. The aircraft experienced an engine power loss and crashed into a wooded area. The aircraft sustained substantial…Accident 20041023027999AAmtr Carata · Minden, NV(-23) Both wings separated from the fuselage in flight due to overload.Accident 20041023027619ACessna T210H · Missoula, MT(-23) Pilot stated that he was cleared to land. He then put fuel pump on low boost, switched tanks, lowered gear, added first notch of flaps, and then noticed he was low on the VASI. He then tried to add power with no response. After trying to restart engine…Accident 20041023026839ACessna 170A · Glenwood Sprin, CO(-23) The pilot reported he was in the normal pattern for runway 32 at Glenwood springs when he decided he was too high and elected to go-around and make another approach to the runway. When he added power, he reported there was little or no response. (He…Incident 20041023025179IBeech 300BEECH · Moses Lake, WA(-23) Lawrence duvan (jake) jacobson the owner had just leveled at FL290 he initiated a left turn when the right windscreen shattered during the return to level flight the left windscreen shattered. He informed ATC of the windscreen failure, slowed the…Incident 20041022029379IBeech 95B55 · Camarillo, CA(-23) On 10/22/04 aircraft registration #N1567A departed long beach CA. At 1913 PST this aircraft reported to sct controll that his aileron trim was stuck and that he was holding full left rudder but was continuing on to camarilo airport, CA. The aircraft…Accident 20041022027899AAmtr Kitfoxii · Vero Beach, FL(-23) The engine failed shortly after takeoff (approx. 250 ft. AGL). Landed in citrus grove.Incident 20041022027199IBoeing 727200 · Salt Lake City, UT(-23) N894AA a 727-200 aircraft operated by the us marshall service (public use) was in the process of having a tire changed on the LH main gear. After the tire had been removed the mechanic noticed that the asphalt was sinking under the jack. In an attempt…Incident 20041022027099ICessna 441 · Eugene, OR(-23) Aircraft enroute from medford, OR to victoria, bc diverted to Eugene, OR due to a windshield de-ice system overheat indication. Investigation determined that during flight the windshield de-ice was cycled to clear water from the nozzles. When it was…Incident 20041022026619IAmtr Dragonfly · Beatrice, NE(-23) On October 22, 2004, at approximately 1300 CDT, mason Dragonfly, N64TM, serial number: 958, experienced a collapse of the main landing gear during touchdown at the Beatrice, Nebraska, municipal airport. The PIC reported a severe downdraft during the…Incident 20041022026599IBoeing 75733N · Victorville, CA(-23) As the captain attempted to do a 180 degree turn (from south to north) on taxiway C-2, the aircraft nose and right main tires departed the concrete and mired in the mud. The captain made the turn in an attempt to enter taxiway C-1. The passengers were…Accident 20041021034309APiper PA31350 · Ft Lauderdale, FL(-23) N61518 experienced engine trouble and the pilot could not maintain altitude. The aircraft made a safe landing in the atlantic ocean. The pilot escaped with minor injuries and was rescued by the U.S. Coast guard. The aircraft sank in 700 feet of water.Incident 20041021031739ICamron A140 · Ravenna, OH(-23) Balloon N6155V, piloted by stephen russell, attempted a landing in a cornfield. During the landing the basket tipped over and was dragged a number of feet. Some of the passengers fell into the pilot and caused him to twist his knee and ankle. Two of the…Accident 20041021029549AUnivar 1082 · Indian River, MI(-23) The subject aircraft enroute from cheboygen airport and landed at Indian River airport. The pilot took off from Indian River airport at 15:00 hours from runway 28. The subject aircraft lift off to 800 feet and the engine quit. The pilot attempted to…Incident 20041021029439IPiper PA28R200 · Carlsbad, CA(-23) Mr. Mohammadi was practicing night touch-and-go landings. He was operating with an inoperative landing/taxi light (not required by FAR for the operations involved). After landing, while clearing the runway, Mr. Mohammadi missed the (lighted) taxiway…Incident 20041021028109ISwftms GC1B · Torrance, CA(-23) The pilot stated that during takeoff he anticipated a left crosswind. The pilot stated that the aircraft started to turn left and he applied right rudder and brake, however the aircraft continued to turn left and at approximately 30-40 indicated…Accident 20041021027659ABeech C24R · Asti, CA(-23) Pilot departed healdsburg CA airport direct to little river CA airport (O48). Pilot and passenger witnessed that left hand fuel tank was selected. Engine failed .7NM nw of cloverdale airport. Pilot switched fuel selector to right hand tank and attempted…Accident 20041021026389APiper PA32RT300T · Guntersville, AL(-23) On 10/21/2004 Mr. Robert thomas webb, pilot of airplane N19TL, while in flight reported a rough running engine to huntsville (hsv) air traffic, during that time the pilot requested a vector to huntsville (hsv). Later in the flight the pilot experienced…Accident 20041021024859ABeech F35 · Chester, AR(-23) N3889B, a BE-35-F35, co-owned and registered to h.n. and patricia mccutchen, was based at the stillwater, ok airport, near the owner's residence of [privacy data omitted] Mr. Mccutchen was a certificated private pilot, certificate #448303700, with a…Accident 20041020032259ACessna 150M · Ashley, ND(-23) The fatally injured pilot of this aircraft was conducting the flight in accordance with 14 CFR part 91, on a flight from bemidji, MN to an unknown destination in south dakota. Damage to the aircraft is consistent with spatial disorientation and loss of…Accident 20041020028339ABoeing 747132 · Detroit, MI(-23) On October 20, 2004, kalitta air (kcsa) operating a B747-132, under 14 CFR, part 121 rules and IFR, departed from kord enroute to kjfk. At approximately 2029 CST, N709CK kcsa, llcas flight 825, the number 1 (one) engine separated from the aircraft while…Accident 20041020026499ABolkms BO105S · Fort Walton, FL(-23) The pilot of the aircraft made a turn to return to base at approximately 300 feet AGL. Witness states that the aircraft began a descent in the turn and did not appear to pull up. The witness did not actually see the aircraft hit the surface.Accident 20041020026069ACessna 172S · Columbia, SC(-23) During landing on rwy 05 at the Columbia Metropolitan Airport (cae), Columbia, SC, the aircraft bounced several times, veered off the left side of the runway, and struck an adjacent taxiway sign approximately 1700 feet from the threshold of rwy 05. The…Accident 20041019035099ACessna 150L · Denton, TX(-23) On October 19, 2004, N6870G, a Cessna CE-150-L aircraft operated by the pilot [privacy data omitted] departed Denton airport, Denton Texas on an instructional flight when the pilot [privacy data omitted] experienced sudden engine failure. On-scene…Accident 20041019034059ABeech 95B55 · Atlanta, GA(-23) Aircraft departed pdk southbound to venice, fla (vnc). Approximately 7 miles south of pdk the pilot reported that he was in "trouble". The controller issued a heading eastbound, the pilot did not respond, shortly thereafter radar contact was lost and…Accident 20041019033429ABag JETSTM3201 · Kirksville, MO(-23) On 10/19/04, about 1937 CST, a british aerospace jetstream 3200, twin-engine turboprop airplane, N875JX, operating as American connection flight 5966 crashed during an instrument approach to the Kirksville regional airport, in Kirksville, MO. The…Incident 20041019031679ICndair CL6002B19 · Flint, MI(-23) During takeoff from Bishop int'l airport, Flint, MI, comair 227 struck two deer. The crew aborted the takeoff and returned to the gate. Aircraft sustained damage to the leading edge of the left wing, two flap jackscrew canoes on the right side, one flap…Incident 20041019031639IAmtr AC5M · Hot Springs, SD(-23) Pilot landed the glider with the main gear not fully extended/locked. Pilot had minimal time in the aircraft. This model of motorglider is new to the pilot.Accident 20041019028249APiper PA28161 · Valkaria, FL(-23) Pilot doing touch & go's at valkyria airport rwy 14. On third attempt pilot felt something hit a/c during take off phase and aborted t.o. and veered off runway into grass. Later notified dead deer on runway.Accident 20041019028179ARobsin R22BETA · Vega Baja, PR(-23) The pilot in command attempted to land his helicopter in a vacant lot with tall grass to drop off a passenger after taking photographs. The pilot realized the grass was too tall decided to abort the landing. In the process the skids got tangled with the…Accident 20041019027699AAerovd L39C · Hayk, WA(-23) The aircraft was IFR enroute seattle Boeing field, WA to lewiston, id at the SEA072041, pilot reported control problems then stated "emergency, emergency, out of control, out of control". The aircraft is missing. (-23 amendment) on October 19, 2004, at…Incident 20041019027399IBoeing 737232 · Kansas City, MO(-23) On takeoff out of mci at rotation the flight crew heard a loud bang - epr rolled back, EGT entered yellow, then the engine indications returned to normal operation. The aircraft continued on to atl where maintenance found the #2 engine nose dome missing…Accident 20041019027279ABeech 95B55 · St Louis, MO(-23) Pilot has stated that he was on approach to rwy 26L at the Spirit of st. Louis airport, chesterfield, MO and broke out at about 800 feet. As he crossed over the approach end of the runway, his approach plates fell to the floor and he believes that as he…Incident 20041019027019IBeech N35 · Arlington, WA(-23) Mr. Jerry pressley landed at Arlington airport on 10/19/2004, with the right main landing gear stuck in the up position. Landing was made in the grass area with minor damage to the aircraft.Accident 20041019024769AChris A1 · Winifred, MT(-23) On October 19, 2004, at 1141 MDT, an Aviat A-1 husky, N79795, registered to curtis hershberger, collided with a tree after exiting a turn while looking for cattle near Winifred, Montana. Visual meteorological conditions prevailed at the time and no…Incident 20041018032669IBeech 76 · West Palm Beach, FL(-23) On 10/18/04, at 0236Z, Beechcraft airplane registration #N278D and serial #ME-23, the pilot called pbi ATCT and told them that his airplane had an unsafe nose gear indication. West Palm Beach police helicopter offered to scan N278D with night vision…Incident 20041018031829IBeech 99 · Milwaukee, WI(-23) On October 18, 2004, at 0815 CDT, a Beechcraft BE-99, N799CZ, operated by commercial pilot konstantyn s. misyukevish landed gear up at Milwaukee General Mitchell international airport (mke). The nose gear actuator failed allowing hydraulic fluid to be…Incident 20041018030929ICessna 152 · Harrisburg, PA(-23) After take-off the engine began to run rough. Performed magneto check and engine smoothed out. Changed heading to return to cxy. Engine began to vibrate and pilot observed pieces departing the aircraft through the cowling. Pilot shut down the engine on…