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 20040505006789IPiper PA28RT201T · Danville, IL(-23) On may 5, 2004 shortly before 1300 local time the appropriately rated and qualified pilot and sole occupant departed palwaukee airport, chicago on an IFR flight plan to chattanooga, TN. While working chicago departure control on an assigned heading of…Accident 20040504020969ASnias AS350BA · Brooklyn, NY(-23) N4NY, acting as "chopper 4", for channel 4 news was hovering, observing police activity in Brooklyn, NY. The pilot advised ATC that he had a tail rotor failure and was heading for sears roebuck (parking lot). The pilot then transmitted "chopper 4 going…Accident 20040504017089ACessna 172N · Tampa, FL(-23) On may 4, 2004, at 1215 EST, a Cessna 172, N737HW, registered to jensen aviation inc., had a hard landing on final approach to runway 080 at Tampa bay executive airport, odessa, Florida, while on a personal flight. Visual meteorological conditions…Incident 20040504015549ICleveland, OH(-23) Passenger [privacy data omitted] became irate during the flight and interfered with a crewmember in the performance of the crewmember's duties in violation of FAR 121.580. Cabin crew and passenger injury summary not known by ASI.Incident 20040504013599ISlinds 100ACMDR · Hillsdale, MI(-23) Landing in crosswind and lost directional control of aircraft on rnwy 28. Aircraft rolled off runway into grass. Nose wheel was broken from aircraft, propeller, cowling and engine mount was damaged. Right wing tip also received minor damage.Incident 20040504013289IBeech 65A90 · Deland, FL(-23) On may 4, 2004 following the completion of a routine training flight the crew prepared for landing, during the safety check the first officer noticed that an unsafe gear indication (red light) was illuminated for the right main landing gear. Following…Incident 20040504011389IPiper PA24250 · Salinas, CA(-23) The pilot noticed an unsafe gear warning on approach to landing. The pilot elected to go around and troubleshoot the situation. After an hour the pilot elected to bring the gear down manually. The pilot stated he could see his nose gear was down using a…Incident 20040504006699ICessna 152 · Columbus, OH(-23) Mr. Nolan was conducting a local photo flight out of Port Columbus (cmh) in a rented Cessna 152. The flight lasted approximately three 3 hours before returning to Port Columbus airport while enroute Mr. Nolan contacted Columbus tower to inform them that…Accident 20040503031239ABeech 65 · Winder, GA(-23) The aircraft departed lzu for wdr at around 2130. According to witnesses, the aircraft engines were sputtering as the aircraft was making a left turn. The aircraft impacted the ground in an open field on the property of [privacy data omitted] which is…Incident 20040503020709IEMB EMB135LR · Richmond, VA(-23) Just after parking at the gate, and after having reset the APU generator to "on", a large amount of smoke was seen emanating from the tail of the aircraft. The captain shut down the remaining engine, #2, and the APU, and discharged the APU fire bottle.…Incident 20040503019909ICessna 172P · Caldwell, NJ(-23) Aircraft N63017, a Cessna 172, called for taxi instructions. Ground control issued instructions for the aircraft to taxi to runway 22, and to hold short of taxiway bravo on the inner. At 1514Z the aircraft hit a construction vehicle, parked on taxiway…Incident 20040503019809IDorner DO328100 · Allentown, PA(-23) On takeoff, cabin door came completely open. Flight attendant reached across aisle to passengers in seats 1D and 1F for assistance. Allegheny commuter pilot deadheading in back of cabin came up front and pulled flight attendant from her seat and to rear…Accident 20040503018239AMooney M20M · Raleigh-Durham, NC(-23) Aircraft was on approach into Raleigh-Durham airport when the pilot became disoriented and failed to maintain heading and direction. The private pilot was instrument rated and attempted two approaches to runway 5L into rdu airport. On the first approach…Incident 20040503013579ICessna 525A · Cincinnati, OH(-23) Aircraft landed on rwy 21L at luk and departed the left side of the runway striking four runway lights. The aircraft sustained minor damage to the belly and left flap.Incident 20040503013509IStemme S10VT · Jean, NV(-23) Investigated an incident that occurred at Jean Airport at approx. 1700 PST on the 3rd of may 2004 that involved a Stemme S-10 VT motor glider, N241LS, owned and operated by steve don miller. The motor glider had apparently ran off rwy 20R damaging the…Accident 20040503009669ACessna 150E · Goldthwaite, TX(-23) N3050J got gas at llano, TX, municipal airport and flew to burnet and then to colman for touch and go's. on the return to llano, TX, the engine quit and crashed at night. The airplane's left wing hit an oak tree spinning the plane around with the tail…Incident 20040503009139IMooney M20F · Meadville, PA(-23) Failure of the pilot to verify that the landing gear switch was in the "down" position; this caused the landing gear to retract before the aircraft became airborne.Incident 20040503008659IBbavia 7GCB · Mayfield Green, KS(-23) On 05/03/04 a champ 7GCB operated by john francis mcmaster and sole occupant (certificate #2156420) made a forced landing in an open field approximately 2.5 miles s/e of Mayfield Green, KS after the aircraft experienced engine failure. The pilot was not…Accident 20040503007199ABell OH58A · Bakersfield, CA(-23) On may 3, 2004, at 2330 pacific time N397E a OH-58A+ helicopter lost power during a turn and made a forced landing on a residential street. N397E was being operated as a public service aircraft with no airworthiness certificate. The commercial…Incident 20040503006679ICessna 310R · Evert, MI(-23) While on a on demand passenger charter flight conducted under 14 CFR 135, the pilot lost consciousness in flight. The passengers managed to control the aircraft, and the pilot, who was reported to be unconscious for a minute or two, regained…Accident 20040502015559AAmtr SZD421 · Hood River, OR(-23) Glider flight originated from Hood River airport at approximately 1130 local. On return flight to Hood River, descending from cloud base of 800 ft., experienced excessive sink rate. Pilot unable to locate areas of necessary lift to maintain flight,…Accident 20040502009419ACessna 150J · Lake Dallas, TX(-23) On may 2, 2004 at 1610 CDT, a Cessna 150J, N60539, was substantially damaged during a forced landing following a reported loss of engine power. During initial takeoff climb from Lakeview Airport (30F), near Lake Dallas, Texas, the pilot attempted to…Accident 20040502007679ACessna U206F · English Bay, AK(-23) On takeoff aircraft began an uncommanded roll left as main gear departed surface. Pilot applied right aileron and right rudder to stop roll, without effect. The left wingtip collided with small rocks about 800 feet from beginning of runway, aircraft…Incident 20040502005779ICessna 152 · Tulsa, OK(-23) Flying second solo flight. After several landings pilot encountered cross wind. Nose veered to the left and pilot corrected with brake and rudder. Aircraft proceeded across the runway and struck a marker light. No injuries and no damage to aircraft.Incident 20040501019969IScwzer SGS233A · Petersburg, WV(-23) Left wing strut attach bolt was not properly installed. Wing separated from glider on take off roll.Incident 20040501019919IAmtr MIG15UTI · Reading, PA(-23) Pilot stated that aircraft departed end of runway 31 at about 5 knots and into the grass about 10 feet. During post landing walk-around, pilot stated that he heard air hissing from right-hand brake assembly and suspected air leak in expander tube.Accident 20040501012269ACessna 172K · Harrisonville, MO(-23) Flight instructor conducting training for student pilot in takeoff and landing maneuvers. Student pilot lost control and instructor failed to recover aircraft.Accident 20040501008759AAmtr VM1ESQUAL · Cambridge, OH(-23) The pilot related that on 5/1/04, during a takeoff roll, the aircraft veered to the left hitting a runway light then it went over some terrain and ended partially submerged in a body of water. Damage was sustained to the left and right wings, the…Incident 20040501008619IBeech V35B · Maitland, MO(-23) Aircraft departed minneapolis, Minnesota (ane) around 07:00 CDT, enroute to topeka, Kansas, (foe), on an IFR flight plan. Pilot states that around 08:45 CDT, while in cruise flight, the aircraft developed a vibration, followed shortly by a loud "bang",…Accident 20040501007619ACessna 182K · Phoenix, AZ(-23) Pilot flared high and landed hard bouncing up off of runway. Pilot faled to make a timely go-around and began nose wheel to mains "crows hop" leading to 3 prop strikes. Pilot lost control of aircraft, left runway and destroyed a taxiway sign and light.…Incident 20040501007289IAmtr Kitfoxiv · Hanford, CA(-23) The aircraft hit a telephone wire that was stretched across a canyon which broke his propeller. The pilot made an emergency landing on hwy 41 west bound. The pilot was transported to tri-city hospital with back pain. The pilot stated he was flying…Accident 20040501007179ACessna 195 · Riverside, CA(-23) On the above mentioned date Mr. Murdock the owner/operator of N195AF accomplished six touch and go landings on runway 27 at the Riverside Municipal Airport. Mr. Murdock requested a fullstop landing. On landing operational control of the aircraft was…Accident 20040501007079APiper PA18105SPEC · Laurel, MT(-23) On may 1, 2004, at approximately 1100 hours (mountain), the pilot and his passenger were flying eastbound directly over the yellowstone river, south of Laurel, Montana, on a sightseeing flight. Just prior to the accident, the pilot was flying at an…Accident 20040501006539ACessna 182A · Elberta, AL(-23) Pilot states that he had experienced minimal, partial power loss on descent at 6000, 4 NM north of airport. He attempted a straight in approach to runway 18 but went around because he felt that he was too high and too fast. On go around, engine lost all…Incident 20040501006009IPiper PA18150 · Hailey, ID(-23) Aircraft experienced engine failure approximately 5 miles north of Hailey Idaho airport during approach for landing. Pilot elected to land in a field by elementary school. Aircraft landing accomplished without incident and with no damage or injury to…Accident 20040501005819AAmtr Skybolt · Philadelphia, MS(-23) Aircraft struck a tower during cruise flight at 1600' approx 11 miles southeast of philidelphia ms on a 140 heading to topton airport in meridian, MS from philidelphia, MS.Incident 20040430019999ICessna 310I · Ocean City, MD(-23) Mr. Jones was attempting to land at Ocean City airport (oxb) on runway 20, when he failed to extend the landing gear.Incident 20040430009469IPiper PA60601P · Kingfisher, OK(-23) Pilot was on the watonga approach when he saw the Kingfisher (F92) airport and elected to discontinue the approach and land at F92. On final approach the pilot encountered heavy tailwind and was unable to stop on the wet grass runway. Aircraft left end…Incident 20040430008269IAmtr RV6A · Tucson, AZ(-23) On April 30, 2004 N971DP was landing at Ryan Tucson, AZ airport when it experienced a hard landing causing damage to the nose landing gear, propeller and engine. The pilot stated that when he flared the airplane during landing, a gust of wind hit him…Accident 20040430007739AMooney M20J · Redmond, OR(-23) Aircraft departed geg, enroute to rdm. On approach rdm, ASOS reported winds variable at 8-11 knots with uncertain gusts. On landing, approximately five feet from ground, a significant gust of wind lifted aircraft and shifted aircraft to the right. Pilot…Accident 20040430007629ASukhoi SU31 · Ft Lauderdale, FL(-23) On April 30, 2004 a Sukhoi SU-31, N31SU operated by a commercial pilot collided with water off the coast of ft. Lauderdale, Florida, while rehearsing for an air show. The personal flight was operated under the provisions of title 14 CFR part 91. Visual…Incident 20040430007299ICessna 172K · Manteo, NC(-23) Immediately after touchdown a gust of wind caused the aircraft to tip slightly sideways and forward. The results were a minor prop strike.Accident 20040430007189ACessna 305A · Taunton, MA(-23) Pilot landed in grass between runway 30 and taxiway. Area used for landing is not an approved landing area and is an unprepared surface. Grass was soft in area of touchdown. Ground scars at site indicate 3 point landing. Gear penetrated surface…Incident 20040430007089IDiamon DA20C1 · Vashon, WA(-23) On April 30, 2004, just after departing gig harbor airport (tiw), at 1,100 feet approximately 12:50PM PST while over channel between gig harbor and Vashon island, WA. Engine abruptly quit producing power, propeller continued to "windmill", but no…Incident 20040430006529IPiper PA24250 · Columbia, SC(-23) The following factors contributed to the gear up landing of N6799P, on may 1, 2004: 1. Mr. Lintner has approximately 3 hours in a Piper PA-24, in the last ninety days, including the flight down to hilton head. 2. The landing gear switch has a neutral…Accident 20040430006319ABell 206L3 · Deadhorse, AK(-23) The pilot was attempting to maintain visual contact with the snow covered surface in IMC conditions consisting of fog and flat light (white out). During the attempted takeoff he lost visual reference due to intensifying fog. When he lost visual…Incident 20040430006239IPiper PA28140 · Long Beach, CA(-23) On April 30, 2004, at 0925 PDT, Piper, PA-28-140, N6740J, landed with a flight instructor, james frederick spowart and student pilot, ralph gary nelson. The pilots stated that the aircraft landed with a side load and the right gear axle failed. The tire…Accident 20040429030549ABeech D95A · Athens, GA(-23) Pilot landed on runway 02 at Athens ga (ahn). Unable to determine touchdown point. From brake marks on the runway it appears that the right brake worked properly and the left brake failed. Aircraft ran off the end of runway 02 where it received…Accident 20040429021229AMooney M20C · Front Royal, VA(-23) During attempted landing, with a crosswind on rwy 9 at frr, aircraft landed hard and bounced several times. Pilot then attempted a go-around by adding full power and raising the flaps. The aircraft departed the left side of the runway in a stalled…Accident 20040429018139ACessna 182P · Soddy Daisy, TN(-23) Aircraft N2277M landed in a field and sustained major damage. The pilot told the local police officers that he had run out of fuel. The pilot identified himself as claude tolbert. The police officer on the scene stated that the pilot appeared to be…