NTSB investigations, NJ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA' ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" 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 c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" 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.
NTSB DCA05MA031Accident · Serious injuriesClass 1 · MajorFinal reportBombardier CL-600-1A11 · Teterboro, NJthe pilots' failure to ensure the airplane was loaded within weight and balance limits and their attempt to takeoff with the center of gravity well forward of the forward takeoff limit, which prevented the airplane from rotating at the intended rotation…NTSB NYC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Millville, NJThe flight instructor's failure to lower the landing gear during landing.NTSB IAD05CA027Accident · Minor injuriesData collectionFinal reportEnstrom 280C · Pedricktown, NJThe pilot's failure to maintain control of the helicopter during the takeoff and his failure to flare during the autorotation.NTSB IAD05LA024Accident · Minor injuriesLimited investigationFinal reportHare Seawind · Trenton, NJThe pilot's improper fuel management which resulted in fuel starvation and subsequent loss of engine power. A contributing factor to the accident was the pilot's inadvertent loss of airspeed.NTSB NYC05IA029Incident · No injuriesIncident investigationFinal reportFairchild-Heliporter Pilatus PC6/B2-H2 · Cross Keys, NJA total failure of the left elevator attachment point for undetermined reasons.NTSB NYC05FA026Accident · No injuriesField investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe flightcrew's inadvertent engagement of the autothrottle system, and their failure to recognize the engagement during landing, which resulted in a runway excursion. Factors were the lack of autothrottle switch guards, lack of an autothrottle engagement…NTSB IAD05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Robbinsville, NJThe repair station's improper installation of the stabilator trim tab. A factor was the pilot's inadequate preflight inspection of the airplane.NTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.NTSB IAD04CA042Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Ocean City, NJThe pilot's deliberate delay of rotation during the takeoff roll, and his subsequent loss of directional control.NTSB NYC04CA199Accident · No injuriesData collectionFinal reportRobinson R44 · Wildwood, NJThe pilot's inadequate visual lookout while conducting a nighttime landing to a dolly, which resulted in a stuck skid, and subsequent hard landing. A factor was the nighttime conditions.NTSB NYC04CA198Accident · No injuriesData collectionFinal reportPettigrew, Richard RV-6A · Williamstown, NJThe pilot's improper flare, which resulted in a hard landing.NTSB IAD04LA039Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Pemberton, NJA total loss of engine power for undetermined reasons.NTSB NYC04LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Pittstown, NJThe pilot's failure to obtain a proper climb rate during a go-around, which resulted in a forced landing and subsequent impact with a tree.NTSB NYC04FA185Accident · 2 fatalField investigationFinal reportCessna A150L · Kinnelon, NJBoth pilots inadequate visual lookout, which resulted in a midair collision.NTSB NYC04LA181Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Farmingdale, NJThe pilot's failure to maintain adequate airspeed which resulted in a stall and collision with wires.NTSB NYC04LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe flight instructor's inadequate preflight inspection, which resulted in an attempted takeoff with contaminated fuel, and a subsequent forced landing.NTSB NYC04LA163Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's inadequate preflight inspection, which resulted in the total loss of engine power due to fuel contamination, during the initial climb after takeoff.NTSB NYC04FA161Accident · 2 fatalField investigationFinal reportBeech E95 · Atlantic City, NJThe pilot's failure to maintain airplane control while performing a go-around after experiencing a loss of power to the left engine for undetermined reason(s). A factor related to the accident was the loss of power to the left engine.NTSB NYC04CA159Accident · No injuriesData collectionFinal reportLuscombe 8F · Andover, NJThe pilot's failure to maintain aircraft control during approach. A factor was windshear.NTSB IAD04LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chatsworth, NJA blocked internal oil passage, which resulted in inadequate lubrication of the blower impeller shaft, and the subsequent partial loss of engine power.NTSB IAD04LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Passaic, NJA total loss of engine power for undetermined reasons. A factor was the evasive maneuver on the ground.NTSB NYC04LA107Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Beach Haven, NJAn encounter with turbulence during cruise flight.NTSB NYC04CA074Accident · No injuriesData collectionFinal reportDanbrook Corbin Jr Ace · Pittsgrove, NJThe pilot's improper flare and his failure to maintain adequate airspeed which resulted in a stall and a hard landing.NTSB NYC04IA054Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Teterboro, NJThe captain's inadequate preflight planning, which resulted in an overrun during an aborted takeoff.NTSB NYC04CA019Accident · Serious injuriesData collectionFinal reportBeech A23 · Salem, NJThe pilot's delay in aborting the takeoff after his failure to obtain a proper climb rate. Factors related to the accident were the tailwind conditions, and the wet turf runway.NTSB IAD04CA001Accident · No injuriesData collectionFinal reportCessna 172P · Sussex, NJThe flight instructor's failure to initiate a go-around. A factor was the wet runway conditions.NTSB NYC03LA195Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.NTSB NYC03CA170Accident · No injuriesData collectionFinal reportBell 47G-2A · Jackson, NJPilot's inadequate preflight inspection and failure to remove a pesticide spraying hose from the helicopter prior to takeoff, which resulted in a loss of control.NTSB NYC03LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Linden, NJThe mechanic's improper installation of the carburetor, and his failure to secure the mixture control wire to the mixture control arm pivot bolt.NTSB IAD03CA060Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Atlantic City, NJThe pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.NTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB NYC03LA120Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shiloh, NJThe pilot's improper in-flight decision to not jettison his load when he realized that he would not clear the trees. A factor was the pilot's inattention to his airspeed at liftoff and on climb.NTSB NYC03LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Ocean City, NJThe pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.NTSB NYC03LA109Accident · No injuriesLimited investigationFinal reportCessna 175A · Ocean City, NJA partial loss of engine power for undetermined reasons.NTSB NYC03FA095Accident · 1 fatalField investigationFinal reportBeech A36 · Farmingdale, NJThe pilot's delayed decision to refuel, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC03LA085Accident · Minor injuriesLimited investigationFinal reportMcCaa Minimax 1500R · Robbinsville, NJA partial loss of power for undertermined reason(s).NTSB NYC03LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control. Factors in the accident were the crosswind and landing at night.NTSB IAD03FA045Accident · 1 fatalField investigationFinal reportBeech A36 · Pomona, NJThe pilot's failure to follow instrument approach procedures. Factors in the accident included the pilot's lack of recent instrument experience and the instrument weather conditions.NTSB NYC03LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Berlin, NJThe pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.NTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.NTSB NYC03LA048Accident · No injuriesLimited investigationFinal reportCessna 172SP · Flemington, NJThe manufacturer's improper assembly of the accessory drive section of the engine.NTSB IAD03LA025Accident · No injuriesLimited investigationFinal reportMooney 20J · Morristown, NJIce in the fuel system, which resulted in restricted fuel flow and a subsequent loss of engine power.NTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.NTSB NYC03FA021Accident · 2 fatalField investigationFinal reportMooney M10 · Fairfield, NJThe inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.NTSB IAD03LA014Accident · No injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe student pilot's improper power management during the short-field landing procedure, and the flight instructor's delayed remedial action.NTSB NYC03LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Morristown, NJThe student pilot's failure to maintain directional control during takeoff.NTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.NTSB NYC03FA008Accident · Minor injuriesField investigationFinal reportPilatus PC-12/45 · Trenton, NJA power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.NTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.NTSB NYC02LA193Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28-B2 · Blairstown, NJThe second pilot's improper in-flight decision to perform a release from the towplane, which did not allow for successful completion of the flight. A factor was the downdrafts.