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 20071123827289IBeech 35C33 · Hillsboro, TX(-23) Aircraft landed on runway with gear in up position, flaps partially extended, resulting in damaging left and right flaps, nose gear doors, fwd belly skin and propeller.Incident 20071123826219ICessna 172N · Salt Lake City, UT(-23) Aircraft dispatched for news watch pilot and one passenger onboard. After landing on runway 35 slc, exited at taxiway K4 intersection, hit 2 taxi lights. Continued to Salt lake jet center tie down area. Pilot said landing and taxi lights were working…Incident 20071122828299ICessna 172RG · Denver, CO(-23) On November 22, 2007 at approximately 1130 MDT, N9320D a Cessna 172RG experienced a gear up landing at the Centennial Airport (apa) Denver, Colorado. The aircraft sustained minor damage. The certified flight instructor and his student pilot were not…Accident 20071122827819ACessna 177 · Auburn, CA(-23) On November 22, 2007, about 1130 pacific standard time, a Cessna 177, N3459T, collided with trees and terrain approximately 1/2 mile northeast of Auburn municipal airport, Auburn, California. Sierra vista aviation was operating the rental airplane under…Incident 20071122827669IBeech 95C55 · Santa Maria, CA(-23) The aircraft landed with the gear partially extended due to a late gear down selection on final approach. Witnesses observed this aircraft, the second aircraft in a formation flight of two, making the final appraoch with the gear up until short final…Incident 20071121832319ICessna 421C · Terre Haute, IN(-23) On November 21, 2007, a commercially rated pilot was landing his Cessna 421-C aircraft, N698DR on runway 23 at the Terre Haute international airport located in Terre Haute, Indiana. This asphalt runway is 9020 feet long and 150 feet wide. During the…Incident 20071121831949ICessna 340CESSNA · Sheridan, WY(-23) This flight from laurel mt to oneill NE diverted to Sheridan WY with a rough running left engine. Alcohol was added to the fuel because of -34 degrees c and the problem was corrected.Incident 20071121831719IDiamon DA40 · Orlando, FL(-23) On November 21, 2007, at 1040 eastern standard time, a diamond 40, N241KM experienced a loss of directional control upon landing on runway 7 at Orlando Executive Airport in Orlando, Florida. The pilot reported that immediately after landing for some…Accident 20071121829599ACessna 172N · Hamilton Twnsh, NJ(-23) Aircraft ran out of fuel.Accident 20071121829559ACirrus SR20 · Newburgh, NY(-23) On 11/21/2007 at 0145(l) instrument rated airman, after missed approach, attempted a second approach to rny 09 @kswf. Weather at the time: wind 250/5, 1/4 mi vis, RVR 2000, ovcst @400, temp/dpt 4/4, fog, mist, altim 3007. Traces show a/c on final…Accident 20071121828799ABeech 95B55 · Carlsbad, CA(-23) The reporting inspector interviewed the pilot on 11/30/07. The pilot stated that there was noticeable vibration in the nosewheel after the first touchdown. The pilot added that he attempted to reduce the vibration on the nosewheel by pulling aft on the…Incident 20071121828329IAmrgen AA1A · Los Angeles, CA(-23) Aircraft was on short final. About 300 feet AGL, the student noticed the engine at 300 RPM. He added throttle with no response from the engine. The student pilot called no power, then the flight instructor took control of the aircraft. The flight…Accident 20071121827919AHughes 269C · Newberg, OR(-23) Student pilot reported that 5 minutes after departure from Newberg, Oregon, at 1500 ft MSL, enroute to aurora, Oregon, the engine made a strange sound and abruptly quit running. Engine power setting was reported in green arc for cruise flight prior to…Accident 20071121826959ABell OH58A · Twin Falls, ID(-23) The instructor pilot in command was teaching hovering autorotation maneuvers when the aircraft struck the ground very hard causing damage to the tail rotor housing. The tail did not strike the ground but suffered a whip lash effect when the landing gear…Accident 20071120830089AMooney M20K · Johnson City, NY(-23) On November 20, 2007 at 2159 gmt, a Mooney, M20K, N252DD, crashed after takeoff from runway 34 at the greater binghamton airport, binghamton, NY (kbgm)with an IFR flight plan to kalb. The current weather conditions were IMC, fog and the visibility…Accident 20071120827139ARobsin R22BETA · Ramona, CA(-23) Instructor pilot was demonstrating a flight maneuver/autorotation and lost control of aircraft. See the attached statement provided by the pilot [privacy data omitted] summarizing the event. Pilot statement: the following is an account of the flight in…Incident 20071119831789IBeech 76 · Fort Pierce, FL(-23) While completing a simulated engine inoperative ILS approach and landing during an instrument rating practical test, the aircraft's left propeller struck the runway, causing minor damage to the propeller blade tips.Incident 20071119831769ILibrty LIBERTYXL2 · Ormond Beach, FL(-23) Student pilot and her instructor spent one hour in traffic pattern to prepare for second supervised solo. Winds were light at the conclusion of dual instruction, and instructor released student for solo practice of takeoffs and full-stop landings. After…Incident 20071119828539IBoeing 737 · Baltimore, MD(-23) Passenger was caught smoking in the aircraft lavatory. He admitted to the flight attendants that he had smoked and tossed the cigarette butt down the toilet. [privacy data omitted]Incident 20071119828269IPiper PA24260 · North Platte, NE(-23) Aircraft landed gear up on runway 17 at North Platte, Nebraska. [privacy data omitted]Accident 20071119827019AAyers S2RG1 · Calexico, CA(-23) The investigating inspector had a telephone conversation with the pilot on November 21, 2007. During that conversation, the pilot stated that he was landing after dispensing his fifth load of product when the accident occurred. He stated that the…Incident 20071119826639IEMB EMB145LR · Omaha, NE(-23) N933JN, an Emb-145-LR, being operated as American eagle flight 4409, departed des moines, IA, enroute to chicago, IL. The pilot declared an emergency and diverted to Omaha, NE. The crew reported to company personnel that they received a lav smoke…Incident 20071119826549ICndair CL6001A11 · Allentown, PA(-23) Aircraft was on the approach phase of flight, at 1000 asel, for runway 6 at abe airport. It is estimated that 5 birds struck the aircraft. Three birds impacted the nose of the aircraft, forward of the windshield and aft of the radome. Two birds,…Incident 20071118829529IBeech A36 · Brownsville, TX(-23) Pilot stated that he was on IFR to port isabel when on approach the gear failed to come down and produce three green lights. Upon several attempts with no action he notified tower. They sent him to brownville airport at which he tried the emergency…Accident 20071118828429ACessna 170B · Nikolai, AK(-23) N170BP departed mcgrath enroute to Nikolai on a special VFR clearance. Enroute the pilot encountered freezing drizzle which accumulated on the windshield, lift struts and the airframe. Upon arrival at Nikolai the windshield was covered with ice and…Incident 20071118828309IPiper PA24260 · Dublin, GA(-23) On November 18, 2007 the pilot [privacy data omitted] was piloting N9333P Piper PA-24-260 from tvc traverse city, MI., to X-60 williston, FL. When he experienced intermittent radio and subsequent electrical power failure while transiting Georgia. He…Accident 20071118828019ACessna 172 · Mc Kinnon, TN(-23) On second approach, pilot stated that he "was in a high flare with extra speed and short on runway." Aircraft departed the end of 08 runway by approximately 168 feet, slid into a ditch and flipped over. Pilot suffered broken arm, one pax minor injury…Accident 20071118826829APiper PA34220T · Houston, TX(-23) On November 18, 2007, at approximately 2030 CDT, a Piper seneca PA-44-220T, struck and killed an animal while landing on runway 9 at the Houston Southwest airport in arcola, Texas. The aircraft sustained minor damage. The multi-engine rated private…Incident 20071118826589IGulstm 200 · Omaha, NE(-23) N706QS, Gulfstream G-200, was being operated by executive jet management, inc. as flight EJA706 from burbank, CA, to teterboro, new jersey. The crew received a bleed light indicator in flight that would not extinguish. The crew shut down the right…Incident 20071117832019IBoeing 7373A4 · Dallas, TX(-23) On November 17, 2007, an swa B737-300, experienced an in-flight failure of the no.2 engine while climbing through FL250 enroute from kdal to klit. The crew reported feeling a severe vibration in the no.2 engine. They secured the engine and made an…Incident 20071117828609ICessna 172RG · Kingman, AZ(-23) Nose landing gear failed to extend prior to landing. Pilot followed emergency procedures and landed aircraft with minor damage to nose landing gear doors. Propeller tips were bent back slightly due to striking ground while windmilling.Incident 20071117828219IPiper PA32R300 · Lawrence, MA(-23) Pilot lost communications and subsequent electrical power. Performed an emergency gear extension. Right gear collapsed upon roll out. No injuries to pilot or SIC.Incident 20071117827349IGulstm 200 · Vineyard Haven, MA(-23) On 11/17/2007 at about 2000 EST the pilot flying [privacy data omitted] lost directional control and the aircraft departed runway 24 at Marthas Vineyard Airport. The aircraft struck a directional sign and a distance marker. There were no injuries to the…Accident 20071117827109ACessna 150M · Muskogee, OK(-23) The pilot of the aircraft [privacy data omitted] was attempting to land on runway 13 at mko. Aircraft rolled through grassy area between runway and taxiway and came to rest off to the left of the runway approximately 450 ft., damaging nose gear,…Accident 20071117827099ACessna 172N · Atwater, CA(-23) On 11/17/2007 the student pilot [privacy data omitted] was conducting his first solo flight at Castle Airport (mer) in Atwater, CA when the accident occurred. The pilot was performing his second touch-and-go maneuver and landed on the centerline on…Incident 20071117826929ICessna 172S · Beaver Falls, PA(-23) Student pilot on solo cross-country was making a landing on runway 10 at bvi airport with at least 3 other aircraft in traffic pattern. Student landed a little fast and hard. Damage was limited to one tip of the two bladed propeller and possibly a very…Incident 20071116828679IBoeing 737823 · St Louis, MO(-23) During cruise flight, windshield cracked. Crew diverted to stl (from dfw) and landed without incident or injury.Accident 20071116828529ACessna 210L · Santa Barbara, CA(-23) 11/16/07 At approx. 1335 local time N987M a Cessna 210-L, experienced a l/h main gear collapse during landing on runway 7 at sba. The aircraft sustained substantial damage to the l/h horizontal stabilizer. The pilot [privacy data omitted] and 1 pax were…Incident 20071116828339IPiper PA28180 · Clinton, MO(-23) According to the pilot's written statement and a copy of the Missouri state highway patrol report, the PIC was unable to activate the pilot-controlled runway lights at the warsaw municipal airport (raw), when he keyed his microphone five times as…Accident 20071116827999APadelt PG371 · Hampton, IA(-23) While making an approach for a routine mid-morning landing, the balloon gondola contacted power lines. The cables attaching the gondola to the envelope broke and the gondola fell to the ground.Accident 20071116827869APiper PA28140 · Murfreesboro, TN(-23) Student pilot made a high approach to runway 18, slipped aircraft to reduce altitude, leveled off above runway, flared in an extreme nose high attitude. Instructor took command, power was added. Aircraft was seen oscillating sharply. After 3…Incident 20071116827209IPiper PA60601P · Latrobe, PA(-23) Right engine oil pressure dropped followed by drop in manifold pressure. Pilot shut down engine, feathered propeller, and initiated emergency landing at klbe. Found right engine oil filter and waste metal contamination. Engine change and teardown…Accident 20071116826999AAmtr Longez · Le Roy, KS(-23) On November 16, 2007, the pilot [privacy data omitted], pilot and sole occupant of a Longez amateur-built wing aircraft departed the elton hensely memorial airport (ftt) in fulton, Missouri (on a VFR flight plan) destined to colonel james jabara airport…Incident 20071116826179IBraero BAE1251000A · Omaha, NE(-23) N515LR, HS-125-1000A, being operated by executive charters, inc., diverted to eppley airfield, Omaha, NE, after the crew received an oil warning light and noticed the oil pressure fluctuating. The aircraft was in cruise flight at FL220 when the crew…Incident 20071115829719IBoeing 7373TO · Hazelton, PA(-23) Cala flight 1170 on "williamsport arrival" to ewr was informed by ATC of "continual moderate turbulence" below FL200. Capt called via pa for seat belts and for flight atten. To secure cabin. In descent, passing FL190, a/c was told to slow to 250 KTS.…Accident 20071115828959AAmtr Sportstar · Erie, CO(-23) On November 15, 2007 at approximately 11:25 MDT, N617EV, an evektor/sport star experienced oscillations and veered off the runway, at Erie, CO airport (eik). The aircraft sustained substantial damage. The flight instructor and the student pilot were not…Incident 20071115828659IPiper PA28181 · Georgetown, TX(-23) Right hand main landing gear strut cylinder failed causing gear to collapse after turn off from active runway in Georgetown, Texas (gtu).Incident 20071115828549IPiper PA34200 · San Diego, CA(-23) Pilot simulated an engine failure at altitude on an instructional flight, could not restart engine. Pilot contacted Montgomery air traffic control tower for landing clearance, and landed without further incident. Pilot statement attached. Report will be…Accident 20071115828129AUrocop EC130B4 · Meadview, AZ(-23) Helicopter N810MH piloted by [privacy data omitted] landed on the south side of the fuel tank facing north with a total of five helicopters already landed and parked. After shutting down the engine the pilot [privacy data omitted] applied the rotor…Accident 20071115827529APiper PA28R200 · Ranger, TX(-23) On November 15, 2007, at approximately 1530 central standard time (CST), an aircraft identified as a Piper PA-28-R-200, N55307 owned and operated by skymates inc. of arlington Texas broke apart and was destroyed on impact near Ranger, Texas during a CFR…