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.
Accident 20040621012699ABbavia 7GCB · Florence, OR(-23) Student pilot landed short of grass runway 33, hit berm with wheel, drifted left toward paved runway. Left main gear collapsed. Propeller sustained strike.Accident 20040621012259ACessna A188B · Prosser, NE(-23) On June 21, 2004, approximately 10:15 CDT, a Cessna A188B, N731MP, serial number 18803003T, departed a private airstrip NE38 near Prosser, Nebraska. The aircraft was flying under 14 CFR 91 rules to allow the pilot to train for 14 CFR 137 flight…Incident 20040621011319IAmtr Velocityxlrg · Laramie, WY(-23) Aircraft landed on a closed runway and hit barricade lighting in the middle of runway. No persons were hurt in this matter. Further investigation revealed that the alternator power wire has blue tape on it at the connector. This allowed the power wire…Accident 20040621011229ACessna 172R · Hartford, CT(-23) On June 21, 2004 at approximately 1210 local EDT, aircraft N356ES, a Cessna 172R, sustained substantial damage when in encountered a hard landing on runway 20 at Hartford-Brainard (hfd) airport in Hartford, CT. The aircraft was piloted by a solo student…Accident 20040621010529APiper PA23250 · Baker, FL(-23) Aircraft penetrated an area of level 4/5 thunderstorms. Pilot asked for deviation to return to crestview, Florida airport (kcew). Radar contact lost. Wreckage/debris field discovered approximately 6.7 miles west of crestview VOR.Accident 20040620026059ACessna 401 · Mt Vernon, IL(-23) On June 20, 2004, at 1830 central daylight time, a Cessna 401, N3234Q, piloted by a private pilot, was substantially damaged when it departed the runway pavement following a hard landing on runway 5 (6,498 feet by 150 feet, asphalt) at mount Vernon…Accident 20040620017459ANamer T28C · New Smyrnabeach, FL(-23) Engine failure shortly after takeoff resulted in off airport landing. Aircraft struck ditch in field which knocked out landing gear. Engine separated from airframe. Wing struck drainage Piper rupturing fuel tanks. Aircraft considered destroyed.…Accident 20040620017429ABeech A23 · Columbia, TN(-23) Pilot landed on runway 23 at Hunter field (06TN) Columbia TN and then initiated a take off struck a fence with left stabilator approx. 250 ft. beyond the departure end of the field and crashed into trees beyond field.Accident 20040620016919ABbavia 7FC · Carmi, IL(-23) The pilot of N7690E was executing his fourth touch and go landing on runway 36 at the Carmi, Illinois airport when he failed to maintain positive control of the aircraft which subsequently exited the runway approximately 1,000 feet from the approach end…Incident 20040620015449IPiper PA28140 · Big Bear, CA(-23) While attempting to land, the pilot encountered a wind gust which caused the aircraft to land hard, nose down. Aircraft sustained damage to the nose gear and propeller.Accident 20040620014059AAmtr TST10M · Enumclaw, WA(-23) On June 20, 2004, about 1748 pacific daylight time, a test TST-10M glider, N410JP, impacted the terrain and was destroyed while maneuvering for landing at the bergseth field airport near Enumclaw, Washington. The self-launching single-seat sailplane was…Accident 20040620013959ACosmos Phaseii · Bandera, WA(-23) On June 20, 2004 at approximately 1715, the pilot flying a Cosmos phase ii airplane, stroke a windsock pole while making a downwind landing to the Bandera airfield WA. The pilot was severely burned due to a post crash fire. The pilot was reported to…Incident 20040620013629IPiper PA32260 · Minneapolis, MN(-23) Aircraft landed on runway 14L and veered off the runway into the north side of the grass striking a runway light and causing minor damage to the left wing flap.Incident 20040620013369IBeech 35B33 · Lebanon, OH(-23) On June 20, 2004, at 1530 EDT, a Beech 35, N1588S, registered to glenn a. spohn, made a gear up landing at Warren county airport (I68), while on a cross country flight. Visual meteorological conditions prevailed at the time and an IFR flight plan was…Accident 20040620013189ACessna 180 · Anchorage, AK(-23) On June 20, 2004, Mr. Schaab, pilot-in-command of N4685A, a Cessna CE-180 on wheels, was landing on runway 24 at the Merrill Field Airport here in Anchorage, Alaska. Just after touchdown, with a wind of about 280 degrees at about 8 knts; about a 40…Incident 20040620011299IPiper PA34200 · Colorado Spring, CO(-23) Two commercial pilots, both with flight instructor ratings, were on a personal flight and landing rw 17L at cos. The flying pilot, Mr. Cox, had landed and was on the roll out with the intention of making another takeoff. The non-flying pilot, Mr.…Accident 20040620010569APiper PA25235 · Gulf Shores, AL(-23) While turning from base leg to final leg of landing approach, pilot in command allowed airplane to stall with insufficient altitude to recover.Incident 20040619033859IAmtr Barracuda · Monett, MO(-23) Pilot was attempting to land at aurora, MO (2H2), when he realized the nose gear was not down and locked. Pilot elected to go to Monett, MO (M58), his home base, and land. Aircraft landed with the nose gear unlocked, damaging the prop, engine cowl, and…Accident 20040619030539ACessna T210N · Ellijay, GA(-23) The PIC reported low level wind shear, which adversely affected the landing at 49A. He said he was unaware of a 30 feet drop-off at the end of runway 21 and continue to land the aircraft. He further stated, the chart of 49A at Ellijay, GA does not…Accident 20040619030419ACessna 172P · Marietta, GA(-23) Pilot-in-command (PIC) was completing his 4th touch and go during his 2nd solo flight as a student pilot. Due to several aircraft in the pattern, the tower reportedly signaled for all aircraft to land and taxi-back. The PIC of N52846 did not realize the…Accident 20040619023979AMncoup 90AL115 · Stcharlescounty, MO(-23) On June 19, 2004 at 90AK-115 monocoupe (clip-wing), U.S. Registration number N1161, operating under a special airworthiness certificate in the experimental exhibition category, departed creve coeur airport (1HO), at 17:55 with two individuals on board…Incident 20040619023599IEMB EMB145XR · Lafayette, LA(-23) Flight encountered severe turbulence at FL 350 15 miles south of lft. 1 minor passenger injury reported. Flight landed uneventfully at iah. Passenger treated and released.Incident 20040619020489IDhav DHC6200 · Hinckley, IL(-23) On June 19, 2004, [privacy data omitted] sustained fatal injuries suffered from a skydiving incident at chicagoland skydive, 12637 rt. 30, Hinckley, IL. (0C2). [privacy data omitted] Parachuted from a Dehavilland DHC-6-200, N223AL aircraft @ 1500 feet…Incident 20040619016329IDoug DC982 · Houston, TX(-23) Aircraft declared an emergency due to an unusual vibration, ground checks revealed a bad rudder pcu, pcu was changed and ground checked ok. M or d report to be filed by operator. No part manufacturer or part number available. Passenger injury summary…Incident 20040619016229IAmtr RV6A · Georgetown, CA(-23) The aircraft had a mechanical failure that caused oil to partially cover the windscreen. The pilot managed to maneuver the aircraft to Georgetown Airport and safely land the aircraft. Due to excess speed he landed long and went off the end of the…Incident 20040619015689IBoeing 7572B7 · Kansas City, MO(-23) On June 19, 2004 us airways N614AU flt. 625 a B-757 advised a.t.c. of an electrical smell in the cabin and declared an emergency. The aircraft landed without incident. Maintenance concluded that the fasten seat belt/no smoking annunciator at row 32DEF…Incident 20040619013859ICessna 172N · Rice Lake, WI(-23) Aircraft was inspected on 06/22/02004 and it was determined that there was a failure of the number 2 cylinder, forcing the pilot to make an emergency landing at Rice Lake airport. When doing so, the pilot touched down on the runway and had difficulty…Incident 20040619013759IPiper PA24250 · Holland, MI(-23) 6/19/04 At 10:43 am Piper aircraft PA-24-250 landed at Tulip City Airport in Holland, MI. At the time of the landing pilot may have accidently retracted the landing gear switch while he is operating the flap. Both the switches area situated close to…Accident 20040619013349AAmtr BERKUTCB540 · Lapeer, MI(-23) Pilot stated that he was experiencing roll problems (left wing heavy) and decided to land at Lapeer airport, D95 to investigate. While following a slower aircraft in to land, he stated that the problem was worsening and that he was having trouble…Incident 20040619011999ICessna 150L · Hayward, CA(-23) Engine lost power on approach to Hayward airport (hwd).Accident 20040619011809AFrchld 24R40 · Lincoln, CA(-23) Pilot stated that he was trying to land in a full stall or three point landing. He had bought the plane the day before and had done only wheel landings (4). He had completed one landing early that morning. The pilot stated that the wing tip came up on…Incident 20040619010839IPiper PA25235 · Fisher Island, FL(-23) Aircraft N7601Z while towing a banner over miami beach lost power, pilot stated that he checked mixture, magnetos on, master on, fuel on, released the banner, tried to reach a golf course, but ditched in government cut. No injuries.Incident 20040619010009ICessna 421B · New Orleans, LA(-23) The pilot selected the gear down. The right gear indicated an unsafe indication. The pilot manually put the gear down. The right gear still showed an unsafe indication. The pilot landed on runway 28, the right gear collapsed. There were no injuries.Incident 20040619009759IBoeing 727251 · San Francisco, CA(-23) On June 19, 2004 air kittyhawk flight 2878 from San Francisco International enroute to fort wayne, Indiana, the crew experienced high oil pressure and rising oil temperature indications from the number 3 engine. They proceeded to reduce power to the…Incident 20040618026659ICessna 210K · St Louis, MO(-23) N8216M was experiencing radio problems. PIC was able to transmit, but was unable to receive on his VHF radio. PIC coordinated through cps ATCT to fly to sus for radio repairs. PIC announced location and intentions on sus ATCT upon arrival. Sus ATCT…Accident 20040618021139AStrman 4E · Loganton, PA(-23) On June 18, 2004 at 1630 with visual meteorological conditions prevailing, Mr. Alan lopez was landing N785H, a stearman-4-E to the west, on a grass runway on the property known as the schrack farm. During landing Mr. Lopez stated that he ended up on the…Incident 20040618020539IEMB EMB135ER · Richmond, VA(-23) The aircraft was parked at the gate. The passengers had already been deplaned. The pilot was dry motoring the #1 engine after a previous hung start. The pilot then observed the fire handle warning light illuminate and then heard the aural fire warning…Incident 20040618019779IBeech 58 · Richmond, VA(-23) Pilot departed Richmond international airport (ric) with one passenger on board. The passenger is an avionics technician employed by million air Richmond. The purpose of the flight was to check the aircraft's autopilot. After departure, at approximately…Accident 20040618019469ARobsin R44 · Killingly, CT(-23) On 06-18-2004, a Robinson helicopter model R-44 registration no. N70144, crashed in a wooded area in Killingly, CT. At 0324 eastern daylight time (EDT). There were two occupants on board, a commercial pilot with flight instructor rotorcraft and…Incident 20040618014259ICessna A185F · Crane Lake, MN(-23) While attempting to land on Crane Lake on a windy and gusty day, the airman misinterpreted the wind direction and at touchdown the aircraft weathervaned into the wind. This caused the upwind wing (right wing) to strike the surface of the water and…Incident 20040618014249ICessna 208 · Detroit, MI(-23) The airplane went off the taxiway into the mud at intersection of the runway 3L/21R & foxtrot (f) and came to rest approximately 243'8" east side of runway 3L and 25' south of taxiway f. the aircraft propeller sustained substantial damage and the left…Incident 20040618013559ISnias AS350B2 · Sparks, NV(-23) Pilot's written statement indicates he performed a recognizance of the intended landing area and noticed no unusual winds in the area of the fire they were supporting. As the pilot set up his landing approach he stated everything was normal until the…Accident 20040618012429AAmtr Quicksilver · Mountain Home, ID(-23) An unregistered, non-certified, two place, quick silver aircraft that was operated by an uncertificated pilot crashed in the desert near Mountain Home, Idaho. The pilot and only occupant of the aircraft, did not survive the crash. There were no…Incident 20040618012289IPiper PA31350 · Valentine, NE(-23) On June 18, 2004, at 1530 local time the pilot of Piper pa 31-350 was back taxiing on runway 32 at Miller field in Valentine Nebraska. He stated he selected the down on the gear selector to check the hydraulic pumps. The right gear slowly came up…Incident 20040618009739IBoeing 737277 · Oakland, CA(-23) On June 18, 2004, america west flight 176 aborted takeoff and returned to Oakland international airport, the crew reported the number one engine vibrated on take off roll, they also reported to ATC a fire warning indication, with no visible fire to…Incident 20040617026579ILear 35A · Lancaster, PA(-23) On June 17, 2004, at 1933 EDT a Lear 35, N357LT aborted takeoff during heavy rain at Lancaster Airport in Lancaster, Pennsylvania. This aircraft was operated by airnet express (bsya), and piloted by peter j. brisker. The aircraft hydroplaned and came to…Incident 20040617023699IBeech D35 · Punta Gorda, FL(-23) On June 17, 2004, at 1315 EDT, a Beechcraft D35, N2963B, registered to Douglas bergner, landed in a field adjacent to the Punta Gorda airport (pgd), after take-off, due to a reduction in power, from the constant-speed propeller. The aircraft sustained…Incident 20040617020529IDoug DC932F · Philadelphia, PA(-23) Following a briefing, which covered the subsequent marshalling procedure between the crew of usa jet (Y2PA) and personnel employed by evergreen aviation ground logistics enterprises, N207US while being marshalled, struck a B-727-243, N1269Y, operated by…Incident 20040617020389ICessna 172R · Cincinnati, OH(-23) Aircraft taxied into building when engine was started. Parking brake was not set and pilot said he pushed on brake pedals but aircraft did not stop.Incident 20040617019859ICessna 182 · Carlisle, PA(-23) Aircraft was operating at 11,500 feet MSL and initiated a descent to pattern altitude at N94. During descent power was at 15" manifold pressure and carb heat was not applied until halfway through the descent. Aircraft was in the traffic pattern on…